12 digits format

[Amy]

Hi there:

Could you tell me how to set a field of numbers in 12
digits by using update query or changing the field format
in the table ? For example, 1234 should be 000000001234
or 1234567 should be 000001234567.

Thanks,
Amy

 

[Wayne Morgan]

Do you want the field to look that way or do you want it to be that way. For it to be that
way, the field will need to be Text data type. To make it look that way, you can simply
format the field.

To set the format in the table, open the table in Design mode. Click on the field, and in
the bottom pane type in

000000000000

where it says Format.

Changing this in the table won't make the change in any forms or reports that you already
have. You will need to do the same thing to the control(s) on each form or report that
uses this value.