HELP with Leading Zero

C

Charlynn

I am using a program called ID works to make ID badges for our facility. We
are changing the configuration of the barcode to 10 digits with the first 4 -
5 digits being a zero.
The access database is not holding the zeros in the table when the data is
saved.
The table is set to be text, with 10 digits. Does anyone have any help?
 
B

B_A_R_T_M_A_N

If it is a text field, you could of done a format statement:

Badgeid = format(ID,"00000")
 
Top