Show "347" as "00347" in a report?

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

Guest

I have a report that is populating a field from a table that saves data as
text.

In the report, 347 is showing as 347 but we want it to display as 00347.

Any ideas?

Thanks for the help!

-Adam
 
AdamZ said:
I have a report that is populating a field from a table that saves
data as text.

In the report, 347 is showing as 347 but we want it to display as
00347.
Click to expand...

Set the Format property of the TextBox on the report to "00000".
 
No luck. Any other ideas? Does it matter that the field I am working with
is "text" and not "number?"

-Adam
 
AdamZ said:
No luck. Any other ideas? Does it matter that the field I am
working with is "text" and not "number?"
Click to expand...

Yeah, that'll do it. Try this expression in your ControlSource instead of
using the format property...

=Format(Val([FieldName]), "00000")
 
Back
Top