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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Right Justified 1
Outlook 365 overriding formatting choices 0
How to create a bubble chart with more than 2 variables. 0
Right justify a string 8
Change how script is viewed on page. 4
VBA Export to PDF 0
Right Justify text 3
Problem with MS Word paragraph and character styles: format getting messed up 2

Top