I have a report that's generated using VBA.
The underlying data source is correct and if I open the report in Design view then look at the datasource for the chart on it, the records all appear as expected e.g.
Jan 20
Feb 20
Mar 20
These are text values, created by taking the first three characters of one text field in a table and appending them to the last three characters of another text field.
However, on the chart when I open the report in print preview they show as five digit numbers e.g.
44255
44253
44393
I've found various ways to change the TickLabel display format for dates and for numbers, but I don't know what should be done to make a text value display exactly as it does in the data source.
There is no formatting being done in the code, other than setting the font size.
The Y axis is just numeric and is being displayed correctly.
The underlying data source is correct and if I open the report in Design view then look at the datasource for the chart on it, the records all appear as expected e.g.
Jan 20
Feb 20
Mar 20
These are text values, created by taking the first three characters of one text field in a table and appending them to the last three characters of another text field.
However, on the chart when I open the report in print preview they show as five digit numbers e.g.
44255
44253
44393
I've found various ways to change the TickLabel display format for dates and for numbers, but I don't know what should be done to make a text value display exactly as it does in the data source.
There is no formatting being done in the code, other than setting the font size.
The Y axis is just numeric and is being displayed correctly.