Keep Field Format (1 Viewer)

Edy

New member
Local time
Today, 15:41
Joined
Feb 13, 2018
Messages
6
I have an AutoNumber that is formatted as "ABC"0000000. If that auto number is the number 123. It displays as ABC0000123. However, the actual value stored in that field is 123. How do I get that field to actually be ABC0000123? Or is there a way to export it as such?

I am trying to link it to a barcode label making program but it only sees the 123 which is not what I need. Any help would be appreciated. Thanks.
 

plog

Banishment Pending
Local time
Today, 17:41
Joined
May 11, 2011
Messages
11,612
that field will never be ABC00000123, its an autonumber. It can only hold numbers.

If its spitting out the correct value, why do you care what it actually stores?
 

Edy

New member
Local time
Today, 15:41
Joined
Feb 13, 2018
Messages
6
Technically, It's not spitting out the correct value, ABC0000123. It just looks like it is. The number being spit out is 123, Access just formats it to look like ABC0000123.

Unfortunately, the program I am trying to send this number to doesn't read the formatting and only receives the 123.

Is there a way to export that field to excel or something as a string?
 

plog

Banishment Pending
Local time
Today, 17:41
Joined
May 11, 2011
Messages
11,612
Yes, but you will have to make a query to format it like you want. Something like:

ID: "ABC" & Format([IDFieldNameHere], "000000")
 

mike60smart

Registered User.
Local time
Today, 22:41
Joined
Aug 6, 2017
Messages
1,899
Hi

I would recommend that you do NOT use the autonumber for anything other than to give each record a Unique Number
 

Edy

New member
Local time
Today, 15:41
Joined
Feb 13, 2018
Messages
6
Thanks plog, that worked well.

I ended up having to use auto number for this because it was the easiest way to auto-generate a unique serial number for each entry.
 

Users who are viewing this thread

Top Bottom