• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Weird text being displayed in query results/Reports.

Wierdtxt
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?

K
0
Karen Schaefer
Asked:
Karen Schaefer
1 Solution
 
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.
0
 
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?

Jim.
0
 
Jeffrey CoachmanCommented:
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...
http://allenbrowne.com/bug-18.html
0
 
Karen SchaeferAuthor Commented:
Jeff,

"There are issue with things like this with memo fields...
http://allenbrowne.com/bug-18.html"

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

K
0
 
Jeffrey CoachmanCommented:
Great.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now