T ThomasAJ Dec 17, 2007 #1 I need to Right Justify and blank fill a string variable. Any easy way to do this other than a character at a time?
I need to Right Justify and blank fill a string variable. Any easy way to do this other than a character at a time?
J John W. Vinson Dec 17, 2007 #2 I need to Right Justify and blank fill a string variable. Any easy way to do this other than a character at a time? Click to expand... Where are you doing this? In data entry on a form, in an update query, or what? You can use an expression like Right(String(25, " ") & strMyString, 25) to left-pad the string in strMyString to 25 characters with leading blanks. John W. Vinson [MVP]
I need to Right Justify and blank fill a string variable. Any easy way to do this other than a character at a time? Click to expand... Where are you doing this? In data entry on a form, in an update query, or what? You can use an expression like Right(String(25, " ") & strMyString, 25) to left-pad the string in strMyString to 25 characters with leading blanks. John W. Vinson [MVP]
