Finding size of memo field

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Bruce
Posts: 43
Joined: Tue Oct 10, 2017 12:44 pm

Finding size of memo field

Post by Bruce » Fri May 15, 2009 9:37 am

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__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Finding size of memo field

Post by kfleming » Sun May 17, 2009 8:46 pm

You can use:____IIF(MEMOFIELD="","This one is empty","This one is not empty")____Kathleen__R&R Support

Bruce
Posts: 43
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Finding size of memo field

Post by Bruce » Mon May 18, 2009 11:46 am

Many thanks!____Best regards,____Bruce__

Post Reply