Microsoft Access Graph Legend Issue

Hi Experts. I have a frustrating issue. I have a graph of instances by machine. One of the Machines is named 10/17. Others are similarly named. In the graph legend for 10/17 it is displaying Oct-17. I made the data source for the graph a temporary table so I could fool around with the data to see if I could get this to display right. When I added spaces to the data making 10/17 - 10 / 17 -- it still displayed as Oct-17. When I changed it to: m10/17 it displayed as m10/17. The machines named 16/17 display correctly since it can't be converted to a month and day. Any ideas?
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Try to add space before value "10/17" --> " 10|17".
Look at Form1 in sample
Database1.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eileen MurphyIndependent Application DeveloperAuthor Commented:
The space preceding the value didn't work in a report/graph. BUT I replaced the slash (/) with a pipe (|) and that works. Thanks for the help. Appreciate it. Here's a screen shot showing where the space before the data didn't work for a report (but did for the form) -- > Graph.jpg
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
As always, thank you!!!
0
NerdsOfTechTechnology ScientistCommented:
Just to add in here an explanation in case another system name will duplicate this issue:

The reason why the graph showed Oct-27 is because the "general" data field that contained 10/27 resembled a date and was cast as a date in the graph; also, since there isn't a 16th month, 16/17 was not interpreted as a date.

Ergo, any character other than "/" and "-" like pipe "|" would keep the data as text instead of be dynamically cast as a date. This also goes for adding a letter, such as m to the data.

There probably is a way to force the graph to display 10/27 with an ' apostrophe in front of the data; or the data column should be cast as text type (as general/variant would attempt to interpret/cast data dynamically into whichever type it thinks the data is in).

'10/27

Open in new window


Assuming it works the same as excel that is
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.