Leading zero's????

[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!!

 

[Cheryl Fischer]

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.

 

[Bob]

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!!

.