If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting numbers in Table of Bar Chart
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 |
#2
|
|||
|
|||
Formatting numbers in Table of Bar Chart
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] |
#3
|
|||
|
|||
Formatting numbers in Table of Bar Chart
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 |
#4
|
|||
|
|||
Formatting numbers in Table of Bar Chart
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 |
#5
|
|||
|
|||
Formatting numbers in Table of Bar Chart
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 |
Thread Tools | |
Display Modes | |
|
|