Truncated Expresssion

[vicktown]

I am calling values from a memo field type using a query expression. The memo is being truncated. How do i stop this?

This is my expression:

Expr3: IIf(IsNull([tblParagraph]![TEXT]),"The text for this paragraph has not yet been entered into the databse",[tblParagraph]![TEXT])

 

[KenReay]

Hi

How about

Expr3: Nz([tblParagraph]![TEXT],"The text for this paragraph has not yet been entered into the databse")

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[vicktown]

It causes the same problem.

tblParagrpah.TEXT is still being truncated.
Is it even possible to call a Memo from an expression and have it stay as a memo style field?

 

[willir]

The memo is being truncated

Memos are not regular fields on a table - they are an object where Access stores the pointer to the memo field. Only the first 255 characters (like a text field) are searchable.