ID Format

[romio]

I really forgot how to do this, how can I change the format of my ID, I have set it up as autonumber and I need to view as

For Example

ACA001
ACA002 etc

The way I have it now is just simple plain numbers 1,2,3,4,5..etc

Thanks.

 

[Mile-O]

What happens after ACA999?

 

[romio]

mm I assume it should go to 2000, the number will be increased always by one I just need to add ACA to Identify it.

 

[Pat Hartman]

If you want to display leading zeros, you'll need to decide how many you'll need. If you have to change the format in a few months or a year, you'll cause a lot of confusion.

"ACA" & Format(YourAutonumber, "00000") <---- some FIXED number of zeros to control the displayed length of the numeric part of the field. If you choose too small and exceed that number, data will appear to be truncated. It won't actually be lost since the format doesn't affect the stored value. It only affects the displayed value.

 

[romio]

Thanks guys Got it fixed.

 

[Bat17]

In the table properties, add to the format property of the Autonumber Field
"ABC"000

Peter