Wierd characters showing in memo field

  • Thread starter Thread starter Don Moore
  • Start date Start date
D

Don Moore

I am getting wierd characters(Japenese) in a memo field on my report. I don't
see any problems with the properies and the records have no data in the
field. Any idea why it is happen?
 
Answered my own question. I turned on totals in the query and the memo field
was set to group by. I changed it to First and that fixed the problem.
 
Don Moore said:
Answered my own question. I turned on totals in the query and the memo
field was set to group by. I changed it to First and that fixed the
problem.
Click to expand...

Yes, that will do it, Don.

Thanks for posting the solution for others who may be searching here.

More info for anyone searching for similar problems:
1. Grouping by Memo field yields garbage:
http://allenbrowne.com/bug-18.html

2. Truncation of Memo fields:
http://allenbrowne.com/ser-63.html

3. Concatenated fields yield garbage in recordset:
http://allenbrowne.com/bug-16.html
 
Back
Top