Multiple Variables in Pie Chart Data Label Formatting

[Bev]

I have recordsin a pie chart that contain the name of the variable, the
dollar cost and the percentage. No matter how the data is formatted, I an
unable to get the currency field, the dollar cost, to format as currency. I
validated the source data and in is formatted as currency but it shows up an
an number with no formatting.

How do I get the formatting in the currency portion of the label

 

[John Spencer]

In the source - whereever you are combining the items - you will need to
use the vba Format function.

Format(DollarCost,"Currency")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Bev]

Not real farmiliar with using VBA. Could you assist me with working the tool.

 

[John Spencer]

No, I cannot. I have no idea exactly where you have combined the items.
Did you do it in the query, did you do it in the report?


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================