Leading Zeros in report Textbox

[rccline]

I have a report with an ID number in a Textbox that I would like to display as 4 digits with leading zeros.

Example:

ID 1 to display as 0001
ID 200 to display as 0200

Can I set the textbox properties to display the number as 4 digits with leading zeros?

Thanks.

Robert

 

[jebry]

Hi!

I don't think you can set the format for that but you can in the control source:

=Format(YourField, "0000")

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst