Getting strange values in memo field

[Haji]

Hello,

I have a memo field in a table called Service2. The
field values range between 30 and 100 characters. When I
go to do a query I get some stange values in this field.
None of the values from the table are appearing in my
query. Every thing is either a square symbol or a square
symbol with a plus sign. Do I need to change a setting
somewhere in order for the real values to appear.

Thanks,

Chuck

 

[Duane Hookom]

Were the values copied and pasted into the table? Is this happening for all
records? You may have a corrupt table.

 

[Gary Walter]

Hello,

I have a memo field in a table called Service2. The
field values range between 30 and 100 characters. When I
go to do a query I get some stange values in this field.
None of the values from the table are appearing in my
query. Every thing is either a square symbol or a square
symbol with a plus sign. Do I need to change a setting
somewhere in order for the real values to appear.

Hi Chuck,

In addition to Duane's sage advise...

Peter Miller once reported getting "garbage"
in memo field of a multitable query where the
tables had no index.

I don't know if that was corrected in an update,
but you might check that table(s?) in your query
properly indexed.

I know it was a "long-shot" but had to respond
just in case.

Good luck,

Gary Walter