return data right justified

[Angie]

I have a make table query with several fields number formatted to 2 decimals.
Any idea how to return these columns right justified? Here's an example of
one of the fields.

FIELD1: FormatNumber([MY_FIELD],2)

 

[Jeff Boyce]

Angie

Instead of using a Make Table query (you are dependent on what Access
decides), create a table that has the fields and formatting you wish, and
append records into it. If you want to 'start over', delete all the records
and (re-)append.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

In your form or report set the Text Align property for the text box to Right.