Graph Formatting - Access 2000

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
 
S

SA

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.
 
G

Guest

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

SA

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.
 

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

Similar Threads

Formatting numbers in Table of Bar Chart 4
Access Combination Chart Types Access 2010 0
Graph Report 3
Column graph problem 4
Cannot get graph to work properly 1
Multiple Variables in Pie Chart Data Label Formatting 3
Access Form Refresh 1
Duane Hookom's Line graph by code 8

Top