I went to 2010/64bit and all my tests are working fine. I was able to group by the memo field, I was able to do first as well. Not sure what is going on.
Looking for alternative to the Memo field or Text field for a Comments field
Competent At Times
Windows 10 
Access 2013 64bit
I went to 2010/64bit and all my tests are working fine. I was able to group by the memo field, I was able to do first as well. Not sure what is going on.
Competent At Times
Windows 10 Access 2013 64bit
So this query works in a form but not a report, is that correct? And the query by itself shows the comment fields correctly, without any funny characters?
Virtually Inert Person
Windows 7 32bit Access 2007
What can't be seen here is the design of the source query you are using as your table. If there's anything in it that will cause any issue, the issue in a nested query usually propagates to the final query, or provides the starting point for a problem. Did you try indexing joined fields in the tables that the first query is based on? Do the comments exist in a table that is joined to other tables in the first query? If so, how does the first query perform? Can you design a query similar to the first that groups to test its performance?
Based on your posts, I think you found this, or something similar to it
http://allenbrowne.com/bug-18.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 7 64bit Access 2010 32bit
Instead of grouping in query, maybe use the report Sorting & Grouping feature.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 32bit Access 2010 32bit
Yes it works on the form but not in the report.Originally Posted by aytee111
Competent Performer
Windows 7 32bit Access 2010 32bit
The forms all utilize a query and the query works correctly. This problem appears in my four reports which are each designed exactly alike. Each report pulls a set of 5 subreports. The query for the subreports is a query of the forms data. Each subreport has a comments fields. When I had the comments field set up as a text field/text box it was displaying the data correctly. Because of size limitations I changed the table to a Memo field/text box and now I am getting special characters only on the reports but not the forms.
Competent Performer
Windows 7 32bit Access 2010 32bit
My mistake...... Sorry. The form runs off of a table and not a query. I cha!nged my report to a table and it is working now!!!!!! Thanks so much
Posting Permissions
Reply With Quote