Squares In Memo Field?

[GarstonMassive]

Hi when I run a query containing several linked tables, little squares appear in the memo field in one of the tables instead of text. This only seems to effect the memo fields.

Moreover if I remove one of tables in the query they disappear but there doesnt seem to be any obvious conflict between the tables.

All fields in the query are set to GroupBy including the memo field.

The text is stored perfectly fine in the table itself.

Can anyone advise?

 

[JoeAtWork]

Little squares" are usually characters that have no visual representation, such as line feeds or carriage returns. Do you see only squares, or a mixture of text and squares?

 

[Golom]

Because memo fields in a table are not actually "in" the table (they are stored elsewhere and the table has only a pointer to them,) there are certain things that can cause problems.

In this instance the memo field will be truncated to the first 255 characters for grouping purposes and attempts to display it will also be truncated. You may need to go to more elaborate SQL to get the full memo field value returned uncorrupted by spurious characters.

 

[TheAceMan1]

How are ya GarstonMassive . . .

Grouping on Memo or OLE types is a very bad idea.

[blue]Unless it contains Memo or OLE Object data, a field in the GROUP BY field list can refer to any field in any table listed in the FROM clause, even if the field is not included in the SELECT statement, provided the SELECT statement includes at least one SQL aggregate function. [purple]The Microsoft® Jet database engine cannot group on Memo or OLE Object fields.[/purple][/blue]

[blue]Do you see the same squares when you look at the table itself? . . .[/blue]

See Ya! . . . . . .

 

[GarstonMassive]

Thanks chaps for your replies.

Yes there are two squares present in each of the fields and there is no text displayed even though some records have text present.

As I say it only seems to happen when I include a specific table in the query. As soon as I remove it the problem disappears.

Weird huh...

 

[danvlas]

2 squares... Look like Chr(10) + Chr(13) from some code or SQL where it should have been Chr(13) + Chr(10) ...

Just a thought...



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html