Chart In Access Reading Range As Date

[NitherWise]

I have a chart in a tab page on a form. The data for the chart comes from a query that has ranges for the service years, < 5, 5-10, etc. For some reason the chart is reading the 5-10 range as a date and displaying 10-May in the chart legend.

The data type for the field in underlying table for the query is text so I'm not sure why this is happening.

Does anyone have any ideas on how to fix this?

Thanks

 

[bat17]

It looks like MSGraph is guessing the data format. Goto design veiw of the form, double click the graph to open it for editing. select the axis and right click> format from the number tab you should be able to set the format to text.

HTH

Peter

 

[NitherWise]

Thanks, but that didn't work. When I changed the format to text, it used the numerical equivalent for the date instead of the value in the source query.

 

[bat17]

Only other thing I can think of is playing with the "Link to Source" checkmark and see what happens. Not much help really

Peter