On 5/29/2022 7:58 AM, Mervyn Bick wrote: > On 2022/05/29 16:29, Charlie wrote: >> Autoincrement field's width is set to 4 and doesn't look like it can >> be changed. Does this mean that it won't go higher than 10,000? >> Hoping not! Thanks for any help. > > The autoinc field type is a LONG value which can handle integer values > i.e. no decimals. The field holds 4 X 8bits i.e 32 bits. This means > the field can hold (in hexadecimal notation) values up to 0xFFFFFFFF. > The decimal equivalent is 4 294 967 295. > > You shouldn't be running out of numbers any time soon. :-)
And my understanding is that when it maxes it the numbers go negative? I
haven't tried to do that, but in theory that could mean double the
potential values.