Re: Formatting lost on report field

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Three (3_at_three.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 19:02:56 +1100

Yep... that sorted it... I was doing the typecast on the report side and it
wasn't working... when I did it in the query it worked fine...

Cheers

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:404b2905$0$22515$5a62ac22@freenews.iinet.net.au...
> Are these calculated fields? If so, I'm guessing that Access does not
> recognise them as numbers, and so is not able to format them as Currency
> 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
> calculation. Details in article:
> Calculated fields misinterpreted
> at:
> http://allenbrowne.com/ser-45.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Three" <3@three.com> wrote in message
> news:undY00BBEHA.1452@TK2MSFTNGP09.phx.gbl...
> >
> > My report has column of money data... the text field formats are all set
> to
> > currency. Before I reworked the report this displayed the figures in
$x.xx
> > format which was good. Now it doesn't do that even though it is still
set
> to
> > Currency... the totals fields in the footer are still working fine, as
is
> > the rest of the report....
> >
> > How can I force these fields back to displaying the data in currency
> format?
>
>

Relevant Pages

  • 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: 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)
  • Re: Formatting lost on report field
    ... 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 ... > How can I force these fields back to displaying the data in currency ...
    (microsoft.public.access.reports)
  • Re: Manually update/change reports details section
    ... at the end of your code in the Detail section's Format event ... >My report is unbounded to any queries or tables and the details are results of different queries and calculated fields. ...
    (microsoft.public.access.reports)
  • Re: format merge field so its $145.50
    ... Further it may depend what yr using to output the report, ... eg if using the Access reports, you can further format the output field of ... In Excell provided you've Formated Fields to Currency, 2 decimal places, it ... >> life of me using either Excel as the data source or Access table to get ...
    (microsoft.public.office.misc)