Format currency field on report.

  • Thread starter Thread starter Louverril
  • Start date Start date
L

Louverril

I know you can "fiddle" a lot with date formats can you do anything with the
currency format?
I don't think this is possible but just in case here goes:

I have a report where I'd like to have the currency fields formatted so that
the currency symbol - in this case £ - is always in the leftmost position.
(I know I could change the format of teh data from currency to a plain
number and then just add a "£" label infront of each field on the report but
I DON'T want to do this.)

So I want the numbers to look like this
£ 3.00
£999.00
i.e. with the pound signs lined up.
NOT like this
£3.00
£999.00

Thanks Lou
 
Open the report in design view.
Select the control.
Open the properties dialog.
Select the Format Tab.
The first option is Format
Enter the word Currency

It will use the currency symbol in your regional settings.
 
You may not want to do the £ separately, but as far as I know that is the
solution.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I know you can "fiddle" a lot with date formats can you do anything with the
currency format?
I don't think this is possible but just in case here goes:

I have a report where I'd like to have the currency fields formatted so that
the currency symbol - in this case £ - is always in the leftmost position.
(I know I could change the format of teh data from currency to a plain
number and then just add a "£" label infront of each field on the report but
I DON'T want to do this.)

So I want the numbers to look like this
£ 3.00
£999.00
i.e. with the pound signs lined up.
NOT like this
£3.00
£999.00

Thanks Lou
Click to expand...


Not only do you wish to align the £ sign but it seems you also wish
to align the decimal point.
I believe you are going to need 2 controls, one for the £, the other,
right aligned, for the number.
Set the number control's Format property to #,###.00
Size it so the largest expected number value will fit.
 
Back
Top