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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
Back
Top