How to display a comma in the data table of a CHART

[avenuw]

Hello,

I have a report with a chart inside and I am also displaying the data table information.I am trying to display the commas for the data inside the table. I did the follwoing but none worked:

1) Changed the field property FORMAT to Standard in the table where the data comes from

2)Have my report in design view and right clicked on the data table, selected NUMBER and checked off box to display the separator (,). Although it displays the comma in the data table in design view, when I preview the report the data table does not have the comma!!!

Thanks for your help

 

[dhookom]

Can you remove the data table and use a subreport to display the values? A subreport would have a great deal of flexibility for formatting the controls.

Duane
Hook'D on Access
MS Access MVP

 

[avenuw]

Thank you, I think that is the only way!!