Piechart-Legend-Zero truncation

[baba]

My legend in the piechart has values like 004,008 etc but while the report is created,the legend has the preceding 0's truncated and 004 is shown as 4 and 008 is shown as 8. Is there a way to fix that and avoid removal of preceding zeros in the legend. Thanks for the help !

 

[vbaInet]

It's been a while since I touched charts in Access but I have a hunch that you should be able to Format the legend. Is there no Format property for Legends?

You can upload a sample db if you feel inclined.

 

[baba]

Unfortunately there is no option to change it to text or prefix the values with zeros in the legend.If you find any otpion please let me know

 

[vbaInet]

I don't have a chart running here. Upload a sample and I'll have a look.

 

[baba]

The only way I was able to force the type to text was by adding a special character colon as a prefix to my data and that works. There may be other solutions but this works for me . Thanks for the help !

 

[vbaInet]

I thought you said your data already had the pre-fixed "0"? Ah, I think you formatted it that was why. If you had used the Format() function directly on the field in the query, it should have affected the display.