Weird text being displayed in query results/Reports.

I am getting weird text being displayed in a Memo and Date fields.  The data does exists in the tables/Forms correctly, however as seen in the picture above not in the report/datasheet.  What can be causing this issue?

Karen SchaeferAsked:
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Care to post the SQL?

<I am getting weird text being displayed in a Memo....>
There are issue with things like this with memo fields...
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
In my experience you have corrupt records.

Make a back up. Rub compact. If that dos nto fix the issue you may need to restore the data from a previous backup.
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Seems a bit odd that it come up in one place correctly and in another not.  What if you look at the table directly?  See anything strange?

 Any chance that a non-english install of Access is part of the picture?

Karen SchaeferAuthor Commented:

"There are issue with things like this with memo fields..."

I looked at Allen's website and I removed the group by off my query and that rectified the problem  Thanks.

Jeffrey CoachmanMIS LiasonCommented:
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.

All Courses

From novice to tech pro — start learning today.