Getting strange values in memo field

  • Thread starter Thread starter Haji
  • Start date Start date
H

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
 
Were the values copied and pasted into the table? Is this happening for all
records? You may have a corrupt table.
 
Haji said:
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.
Click to expand...
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
 
Back
Top