help - I need to add zeros to beginning of a field for every entry

[skd2726]

I have a db that all the fields are will be exported in txt format into another system, in one field the users will enter a 5 digit number but when it exports in txt format it needs to export as an 8 digit field

Example:

user enters 12345
exports as 00012345

Any suggestions?

 

[grnzbra]

Create a loop:

dim str as string

str = EnteredNumber

while len(str)<8
str = &quot;0&quot; & str
loop

or something like that