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

O

Outshine26

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
 
K

Ken Snell [MVP]

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.
 
D

Dave Patrick

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
 
O

Outshine26

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

Ken Snell [MVP]

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.
 
Top