numbers

[Carrie]

Hi, this is probably a very silly question but, I have a
field in my table where we enter a line number. This
could be any number but, is often 01, 02, 03... I need the
0 to show up but for some reason can't figure it out. I
have the fields set as long integer and the format as
general with 0 decimal places. What am I doing wrong?
Thanks!

 

[Lynn Trapp]

Set the format property to 00 (use more zeros if you expect to ever have
more digits) or, else, change the field to a Text field.

 

[John Vinson]

Hi, this is probably a very silly question but, I have a
field in my table where we enter a line number. This
could be any number but, is often 01, 02, 03... I need the
0 to show up but for some reason can't figure it out. I
have the fields set as long integer and the format as
general with 0 decimal places. What am I doing wrong?
Thanks!

Assuming that a number will by default be shown with leading zeros.
The number 1 and the number 01 and the number 00000000001 are simply
three different ways of writing the same number!

Set the Format property of the field to

00

(two zeros) to display two digits, regardless of the size of the
number. Your hundredth line will now become a problem.