show calculated value as a number (right aligned)

[RSunday]

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

 

[Allen Browne]

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

Someone can then suggest how to adjust it.

 

[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.

 

[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.

 

[KARL DEWEY]

Open the query in design view, click on the field, right click and select
Properties. In Format enter the character of the shifted back slash. It
will look like the | even though on the keyboard it looks like two vertical
dashes, one above the other.
--
KARL DEWEY
Build a little - Test a little

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.

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.