MS Graph within Access

W

WTG

Have an access 2002 form with an embedded graph. The
graph is a bar chart/line chart combination and the data
table is shown. Bar chart is of currency and line chart
is general number.
The underlying query and tables have currency formating
defined for the data fields. However, the data table in
the graph does not show the currency format ($). If you
activate the graph, you can change the format in the
datasheet but when you reopen the form, this formatting is
not saved.
Any way to specify format so that it remains?
Any help would be appreciated.
 
Top