Add Leading Zeros To Alphanumeric Text

[Micheleaz]

I'm learning as I go and this is probably a basic question but if I have an alpha numeric field of variable lenght, i.e. AUI856Z....how to I format it so that it is 19 characters long with leading zeros, i.e. 000000000000AUI856Z.

 

[pbaldy]

Try

Format(FieldName,"0000000000000000000")

 

[Micheleaz]

uggggg....it didn't work. It right justified everything but didn't put the zero's in. Does it not like adding leading zero's to alpha?

 

[pbaldy]

Sorry; that works for numbers, I've never tried it on alphanumeric. This works, though it's a kludge:

Replace(Format([password],"@@@@@@@@@@@@@@@@@@@")," ","0")

 

[Micheleaz]

You're a beautiful man!
It worked!...thank you

 

[raskew]

Hi -

Look in the Help File under Space() function. If that doesn't work for you please post back. Can provide a slightly more complicated UDF that will insert necessary characters either in front of, or behind of, the string in question.

Best wishes - Bob