Why do I have symbols instead of words in memo field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my Table, the words are in the field, but in the query & report, I get one
rectangle in the field. The problem recently happened & I'm not sure what I
did to cause it. I've compared the problem field with other similar fields &
I can't see what's different. Using Windows 2000
 
Chances are, you're using Group By on that memo field in the query. Change
it to First. It's a quirk that can happen with memo fields.
 
Also I think memo fields store (among others) carriage returns Chr(13)

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| In my Table, the words are in the field, but in the query & report, I get
one
| rectangle in the field. The problem recently happened & I'm not sure what
I
| did to cause it. I've compared the problem field with other similar fields
&
| I can't see what's different. Using Windows 2000
 
Yes, but when I change it to First and I bring up a report with those
comments in there, I get a window asking me to enter a parameter value. I
don't want that. Any suggestions?
 
That is because the name of the field will change to put FirstOf in front of
the memo field's name. You'll need to change the control source of the
control in your report that is bound to this field.
 
Back
Top