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

[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

 

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

 

[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

 

[Guest]

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?

 

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