PDA

Click to See Complete Forum and Search --> : Padding with zeros

desquite
Nov 21st, 1999, 08:35 PM
What is the easiest way to pad an 11 digit field with 0's?

Thank you.
coox
Nov 21st, 1999, 08:54 PM
Why not just use:

MyString = Right("00000000000" & MyString, 11)
desquite
Nov 21st, 1999, 09:11 PM
Thanks. That worked great.