Fixed Width Expression

D

Dwight

I am building an expression in a query that concatenates several fields
together into a fixed width string. The problem I am having is with the NAME
field. Name holds 27 characters in length, using characters 11-38 of the
string. If the name is less then 27 charcters I need to add the remaining
spaces so the next field in the string begins at postion 39.

I tried using the format command to force 27 characters:

Format$(Mid(qryPrefPers!Name27,1,27),"@@@@@@@@@@@@@@@@@@@@@@@@@@@")

The extra (white) spaces are added to the beginning of the name instead of
the end.

Is there a way to get the extra spaces after the name field?

Thanks in advance!

Dwight
 
D

Dwight

Dennis,
Thanks for your response.
I feel a little stupid because all I forgot that I could use the "!" to
force left to right fill of the place holders.

Format$(Mid(qryPrefPers!Name27,1,27),"!@@@@@@@@@@@@@@@@@@@@@@@@@@@")


Thanks again!

Dwight
 
Top