Need to Pad Zeros

  • Thread starter Thread starter Dee
  • Start date Start date
D

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
 
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.
Click to expand...

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