Display "00001" in a form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

displaying leading zeros in unbound textbox 11
Postal code field 2
Automatic Form Completion 6
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access 2003 SP3 dropping preceding zeros on formatted number field 1
Number Format dropping preceding zero on 1 User's form 1
Pivot Table Display Question 3
Scroll through pictures in a folder 2

Back
Top