Format currency field on report.

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
 
K

Klatuu

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

John Spencer

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

fredg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting currency within a report text box expression 1
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
formatting currency field 2
Currency format with 2 decimals not showing on report 2
custom currency formatting 3
Foreign Currency on Reports 1
Date Format 8
Month in title of monthly report 4

Top