Format numbers

  • Thread starter Thread starter jwr
  • Start date Start date
J

jwr

On my invoice, I want the "line item" to read 001. When I input 001 and
return, the info changes to 1.

How do I change this?

Thank you
 
Open your form in design view, and set the Format property of this text box
to:
000
It stores the value as a number, but displays the leading zeros.

You could also change the field in the table to a Text field instead of a
Number field, but that's not as good an idea.
 
Back
Top