Using Cstr funtion, now how to justify?

[wolves]

Converting a number to string using Cstr, but everything is left justified. How can I make my converted text right justified? Have not found a way yet,

Thanks, in advance,

 

[lespaul]

you mean in the query results?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

Have a look at the Format function:
Format([Number field], "@@@@@@@@@@")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wolves]

Yes, in the query results.

Yes, I'll check out the Format([Number field], "@@@@@@@@@@")

Thanks

 

[wolves]

The Format([Number field], "@@@@@@@@@@") formats everything left justified still.

Any other ideas?

 

[PHV]

Right(" " & [Number field], 20)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wolves]

Thanks, I tried the Right, but apparently had the incorrect format.
This worked.
Thanks again.