Right Justified?

[softlad]

Hi

I have a Text Field which is 12 Character long and Contains;
"ABC " and I want to move it to a new field
Like this " ABC". The target field should not
contain any leading spaces and be truly right justified!
Any help would be great.

Ta in Advance!

Paul

 

[braindead2]

from access help
LTrim, RTrim, and Trim Functions
Returns a Variant (String) containing a copy of a specified string without leading spaces (LTrim), trailing spaces (
RTrim), or both leading and trailing spaces (Trim).

 

[MichaelRed]

braindead2, you are too kind!

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[Nordyck]

If you want to put spaces in front of the string, try this
right(" " & trim(st),12)
st is the string that your converting. Be sure to have 12 spaces between the quotes.

If this is on a textbox then use trim(st) and set the justification to right.