How to Right Justify a string variable.

T

ThomasAJ

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

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]
 
Top