Formatting numbers in Table of Bar Chart

B

Bev

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
 
M

Marshall Barton

Bev said:
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.
 
D

Duane Hookom

Rather than using the Table of Bar Chart, have you considered using a
subreport? This would give you much greater control of the display.
 
B

Bev

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??
 
D

Duane Hookom

I don't know if there is a solution since I prefer using a small subreport
under the chart to display the numbers.
 

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

Top