Right Justify a field in Access

[CTRosebud]

I have a text file that I import into Access. The field comes in as "Double". I need to know how to right justify the filed. I have the following code Expr1: Space(17-Len(Format([Field13],"Currency&quot)) & Format([Field13],"Currency&quotbut I need to change the field to text for this to work and it puts dollar signs in. I need the data to look like 182.12 right justify so that when I export back out to a text file it is to the right without the dollar signs

 

[MichaelRed]

you can set up an import spec to over-ride the field type to text/string. you cannot force a (numeric) field type to a specific 'text width' or justification within a table, although you could do so via a query and some functions. In a query, you could use something like:

Expr1: Right(String(17, "0&quot & Trim(CStr([Field13])), 17)

and then use transfertext with appropiate args to send the query results back to a text file

MichaelRed
m.red@att.net

Searching for employment in all the wrong places