How do I display leading zeros for a numeric field in a report?

H

Hook24

In order to have output conform to a template, I need to have a numeric field
display with leading zeros to always fit a predefine 8 character wide space.

e.g. 17.50 needs to be output as 000017.50 ideally as 00001750
or 132.45 would be 000132.45 or ideally 00013245

Thanks in Advance
Jeff
 
F

fredg

In order to have output conform to a template, I need to have a numeric field
display with leading zeros to always fit a predefine 8 character wide space.

e.g. 17.50 needs to be output as 000017.50 ideally as 00001750
or 132.45 would be 000132.45 or ideally 00013245

Thanks in Advance
Jeff
Click to expand...

To display 17.50 as 00001750 set the control source of an Unbound
Control to:
=Format([YourField]*100,"00000000")
 
Top