Prev: Multiple charts
Next: Select records based upon calculated totals
From: Bev on 9 Dec 2009 11:54
I cannot get my report to retain the currency format when previewed. It
looks fine in design view, but does not retain it. I have changed all of the
underlying queries and tables to include currency formatting.

Any help would be appreciated

From: Marshall Barton on 9 Dec 2009 12:31
Bev wrote:

>I cannot get my report to retain the currency format when previewed. It
>looks fine in design view, but does not retain it. I have changed all of the
>underlying queries and tables to include currency formatting.


With the report open in design view, setting the report text
box's Format property to Currency should take care of it.

The formatting you specified in a table or query are used
when you look at the table/query's datasheet. The only time
it has anything to do with a form is when you drag the field
from the form's Field List to create a new text box. In
this case, Access sets the text box's Format property for
you.

--
Marsh
MVP [MS Access]
From: Duane Hookom on 9 Dec 2009 15:22
Rather than using the Table of Bar Chart, have you considered using a
subreport? This would give you much greater control of the display.
--
Duane Hookom
Microsoft Access MVP


"Bev" wrote:

> I cannot get my report to retain the currency format when previewed. It
> looks fine in design view, but does not retain it. I have changed all of the
> underlying queries and tables to include currency formatting.
>
> Any help would be appreciated
>
From: Bev on 9 Dec 2009 16:17
I like using the table because it lines up directly under the data in the
chart and it provides a legend. Based on your response, I suspect that there
is not a solution to this problem??

"Duane Hookom" wrote:

> Rather than using the Table of Bar Chart, have you considered using a
> subreport? This would give you much greater control of the display.
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Bev" wrote:
>
> > I cannot get my report to retain the currency format when previewed. It
> > looks fine in design view, but does not retain it. I have changed all of the
> > underlying queries and tables to include currency formatting.
> >
> > Any help would be appreciated
> >
From: Duane Hookom on 9 Dec 2009 17:31
I don't know if there is a solution since I prefer using a small subreport
under the chart to display the numbers.

--
Duane Hookom
Microsoft Access MVP


"Bev" wrote:

> I like using the table because it lines up directly under the data in the
> chart and it provides a legend. Based on your response, I suspect that there
> is not a solution to this problem??
>
> "Duane Hookom" wrote:
>
> > Rather than using the Table of Bar Chart, have you considered using a
> > subreport? This would give you much greater control of the display.
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "Bev" wrote:
> >
> > > I cannot get my report to retain the currency format when previewed. It
> > > looks fine in design view, but does not retain it. I have changed all of the
> > > underlying queries and tables to include currency formatting.
> > >
> > > Any help would be appreciated
> > >
 | 
Pages: 1
Prev: Multiple charts
Next: Select records based upon calculated totals