Format numbers

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
 
A

Allen Browne

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.
 
J

jwr

Thank you
Allen Browne said:
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.
Click to expand...
 
Top