Re: Format currency field on report.

On Thu, 13 Dec 2007 09:45:03 -0800, Louverril wrote:

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


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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: Emailing a Report
    ... "What do you suggest for making sure text on the report is not overlapping, missing, and or out of order? ... I always add icons to my toolbars to make it easier to format forms and reports... ... Align Right -- must have>1 control selected to be enabled ... on the report -- when it generates the reports, if a User_ID has 2 reminders, are they now both showing up on the report? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem changing format from number to currency
    ... Please go back to your datasheet view and try again. ... Just search out and report back. ... > aligning it but none of these changed the format. ... > format, currency was listed there. ...
    (microsoft.public.access.reports)
  • Re: Formatting lost on report field
    ... I was doing the typecast on the report side and it ... > even though the Format property of the text boxes is set to Currency. ... > If they are calculated fields, the solution may be to typecast the ...
    (microsoft.public.access.reports)
  • Re: Problem changing format from number to currency
    ... > have based my report on and is the record source of the ... > numbers even though the format of the field is text. ... >>Duane Hookom ... >>> format, currency was listed there. ...
    (microsoft.public.access.reports)
  • Negative number alignment
    ... I have a report where the numbers in a column will not align. ... sure controls are the same width, aligned, same format and alignment. ... But this seems to move ALL the txtDueAmt values, ...
    (microsoft.public.access.reports)