Truncated memo field

[brews]

Am using three different types of fields in an IIF statement., logical, text and memo. However, not all of the memo field displays. This is only part of the Select statement:

IIF(logical_field,'text ' & text_field, memo_field) AS CombinedField.

Query properties Unique Value is set to 0.

The contents of the memo field does not display completely even if it is the only field in the query.

Any ideas would be great.

 

[PHV]

Usually a memo field involved in a function returns 255 characters max.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[brews]

If I use this: SELECT memo_field FROM tblComments in Access, without any function, the field is still truncated.

 

[fneily]

See:
Truncation of Memo fields

http://allenbrowne.com/ser-63.html

 

[brews]

Thank you. Saw that yesterday. There is no aggregation, Uniqueness is No, No Format of property, nothing concatenated. Tried the Union All Select and results are the same.

 

[PHV]

Could you please post the whole minimum SQL code exhibiting this behaviour ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[brews]

Thanks.

SELECT Lastname, Comments FROM Members ORDER BY Lastname

Some of the data in the Comments memo field will be blank, some will have over 100 words. In short, these will be members bios.

 

[Remou]

Have you ensured your Jet engine is up-to-date?

http://support.microsoft.com/kb/239114

 

[brews]

Thanks for reply. Yes, anyone running XP or higher already have an engine greater than 4.0 sp8. mine is 4.0.9704

 

[dhookom]

When asked for your SQL I would expect you to copy and paste the SQL statement into a reply (that is the easiest and most accurate method). However, your reply

SELECT Lastname, Comments FROM Members ORDER BY Lastname

doesn't include a [red];[/red] so I wonder if the real SQL is as stated.

Duane
Hook'D on Access
MS Access MVP

 

[brews]

It is as stated. Access 2007 runs with or without the semicolon.

 

[brews]

In addition, 2007 adds the semicolon when closing Access.

 

[dhookom]

Do you have an input mask or format property on the field in the table design or query column properties.

Duane
Hook'D on Access
MS Access MVP

 

[brews]

No to both.

 

[dhookom]

Does this happen with all tables with memo fields? Are there any way that you can get the entire memo field to display in any query from any table on any PC in any MDB?

Duane
Hook'D on Access
MS Access MVP

 

[brews]

The Memo field displays correctly if I read it correctly. Thanks to all for the suggestions.