Display "00001" in a form field

A

Adam

I have a number/long integer field that can have up to five numbers in it.
The format value in the table for the field is "00000".

When I load the field in a form "00001" displays as "1". Is there any way
to have it display the full number?

Thanks,
AZ
 
K

Klatuu

You don't need to format the field in the table. You format it when you want
to display it to a user in a form or report:
Format([MyField], "00000")
 
Top