Hi all,

I would like to have a text box thats a running sum in a report. But I would like to start it with 001 instead of 1. It will continue for each record, 002,003, and so forth. Is this possible?

Thanks you!
Estee

Yes.

Set the control Source to =1 and the running sum to yes. The set the format property to 000.

HTH.

This works. But, oddly enough when I try to concatenate this field with another field, it just removes those beginning zeros!

You need to carry the format into the concatenate expression as well.

The concatenated field is: A text field that is always the same thing, and this running sum field. I tried formatting the 001 in the contcatenated field too, stil doesnt work.
Thanks

Is the control source for your new text field: =Format([RunSum],"000") & [OtherFieldName]