Format currency field on report.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louverril - 13 Dec 2007 17:45 GMT

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

Reply to this Message

Klatuu - 13 Dec 2007 18:50 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> I know you can "fiddle" a lot with date formats can you do anything with the
> currency format?
[quoted text clipped - 15 lines]
>
> Thanks Lou

Reply to this Message

John Spencer - 13 Dec 2007 20:38 GMT

You may not want to do the £ separately, but as far as I know that is the
solution.

Signature

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
[quoted text clipped - 18 lines]
>
> Thanks Lou

Reply to this Message

fredg - 13 Dec 2007 21:03 GMT

> I know you can "fiddle" a lot with date formats can you do anything with the
> currency format?
[quoted text clipped - 15 lines]
>
> Thanks Lou

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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message