Graph Formatting - Access 2000

  • Thread starter Thread starter DW
  • Start date Start date
D

DW

I have designed a graph and I want the data in the data
table to be formatted as currency, but it only displays
currency in design mode. I was wondering if there is a way
to get the graph to display the data as currency when the
graph is previewed.

Thanks
 
Right click on the Data Grid when chart is opened on the column that would
hold the data series. Bring up the Number property to set the currency
format.
 
Thank you - I tried this and the format doesn't hold when
I preview/print my chart/report. Is there any other way to
force the currency format?
 
Anon:

See our web, in the Code and design tips area, under reports for the topic
"Solving Common Problems with Graph" which will show you some code you can
use to force the formatting.
 
Back
Top