Page 1 of 1

Finding size of memo field

Posted: Fri May 15, 2009 9:37 am
by Bruce
Hi,____I need to check, within a report, if a memo field (.FPT) has any content. I have tried using the LEN() function which works for normal fields but does not work for memo fields. Can anyone help with this please?____Regards,____Bruce____PS: I use R&R 12.5v__

=> RE: Finding size of memo field

Posted: Sun May 17, 2009 8:46 pm
by kfleming
You can use:____IIF(MEMOFIELD="","This one is empty","This one is not empty")____Kathleen__R&R Support

==> RE: Finding size of memo field

Posted: Mon May 18, 2009 11:46 am
by Bruce
Many thanks!____Best regards,____Bruce__