Need to Pad Zeros

[Dee]

I have to count the records and show the count in a field
that's 8 characters long, zero-filled [i.e. 00000023].
Each day the count will be different and the number could
be 1,23,345,or 2000.

I can only think to check the length of the final ttl and
then pad the field with "00" based on length.

Do I do that with a module? Not sure how to get started
or the right commands...

Would appreciate any help...
Thanks in advance,
Dee

 

[John Vinson]

I have to count the records and show the count in a field
that's 8 characters long, zero-filled [i.e. 00000023].
Each day the count will be different and the number could
be 1,23,345,or 2000.

I can only think to check the length of the final ttl and
then pad the field with "00" based on length.

You're making it MUCH harder than it needs to be.

Set the Control Source of a textbox on your form to

=DCount("*", "[name of your table]", <optional criteria>)

Set the Format property of the textbox to

"00000000"