show calculated value as a number (right aligned)

R

RSunday

When I divide two numbers in a query the result is displayed left aligned.
How do I get it to be right aligned?
 
A

Allen Browne

Post the expression you have in the Field row of your query.

Someone can then suggest how to adjust it.
 
K

KARL DEWEY

Open the form or report in design view, click on the textbox, click on menu
VIEW - Properties. Scroll down near the bottom to Text Align and enter Right
in stead of the General.
 
R

RSunday

Sounds good - but where exactly do I click to be able to set this property in
a query?

I have not made a form or a report - I just have the query with a calculated
field:

ExchRate: FormatNumber([spb].[nettoval]/[spb].[nettovalincurrency];3)

This value is displayed left aligned when the query is executed. I want it
to be right aligned.
 
Top