Leading zero's????

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is there an easy way of displaying leading 0's to numbers
in a report??

For instance: 00042

In excel I can put an apostrophe in the cell and it will
display all the 0's.

Thanks in advance for your help!!
 
You can use the format function:

Format([MyNumberField], "00000")

If the value of MyNumberField is 42, the function will return 00042; if the
value is 376, the function will return 00376, etc.
 
Thank You!!
-----Original Message-----
You can use the format function:

Format([MyNumberField], "00000")

If the value of MyNumberField is 42, the function will return 00042; if the
value is 376, the function will return 00376, etc.

--

Cheryl Fischer, MVP Microsoft Access



Is there an easy way of displaying leading 0's to numbers
in a report??

For instance: 00042

In excel I can put an apostrophe in the cell and it will
display all the 0's.

Thanks in advance for your help!!
Click to expand...


.
Click to expand...
 
Back
Top