Memo field, testing for empty - Newbie here

  • Thread starter Thread starter Hank in KC
  • Start date Start date
H

Hank in KC

I have a memo field [Notes] that may or may not contain data. I would like
to print any data in the field with a report, and have a text box containing

=IIf(IsNull([Notes]), "", [Notes]) I have also tried
IIf(IsNull([Notes]), , [Notes])

Both expressions result in error messages. I'm wondering if Null is the
correct way to test for an empty memo entry.

If there is info in the field I would like to print out something to the
effect

"Notes: This account .... blah, blah................

and think possibly something like IIf(IsNull([Notes]), , "Notes: " &
[Notes]) could work.



TIA
 
Could you please quote the EXACT error message.

A String is NULL, if it has never been assigned a value.
Search Access Help for "AllowZeroLength Property",
this will enable you to force a NULL in blank MEMO
(and text) fields.

Your first IIF statement looks ok.
--
Hope this helps!

Pat Garard
Australia
apgarardATbigpondDOTnetDOTau

"One look is worth a thousand rumours."
Wen Hou, Warring States Period.

"Look twice!"
Pat Garard, 2003.
 
The exact error message is #Error

I also changed the property to allow zero length. Same error!

TIA
 
Ye Gods and little Fishes!!!!!!!!!!
No Error NUMBER???
--
Hope this helps!

Pat Garard
Australia
apgarardATbigpondDOTnetDOTau

"One look is worth a thousand rumours."
Wen Hou, Warring States Period.

"Look twice!"
Pat Garard, 2003.
 
Back
Top