access 2003 zero fill field

N

NC Beach Bum

I must zero fill a text field in a query but not sure how to go about it.
Suggestions anyone?

Thanks!
 
N

NC Beach Bum

Cham,

Thanks for the tip!
Your answer led me to the following solution to resolve right justification
of data with leading zero's to pad the data in a fixed length field.

Checks dollar value = ChecksAmount
The character field is a fixed 10 characters in length.
The line of code used:
ChkAmt: String(10-Len(LTrim([ChecksAmount])),"0") & [ChecksAmount]

The output ended up as
0000008192
0030128300
etc.

Thanks! again.
 
Top