I have a record counter of 4 digits. as new records are entered the count increases by one. I need to show the record number with zeros to the left of the counting digits. ie record 50 needs to read 0050 . thak yuo
I have a record counter of 4 digits. as new records are entered the count increases by one. I need to show the record number with zeros to the left of the counting digits. ie record 50 needs to read 0050 . thak yuo
Not much info. Since you posted in a general part of the forum, maybe you just need to put 0000 in the format property of what i assume is a number field in a table?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
In case you need to save record number with real 0's at left, not simply formatting the field or control, the field must be text one. The formula to calculate the value saved to field will be
Code:=RIGHT("0000" & CStr(RecordNumber), 4)