I wonder how to determine if a field is containing some text, any text. I can see the function IsEmpty determines if the field is without text but I want to perform a script that moves to a only records that are empty so I need to bypass records that already have entries.

Thanks

not IsEmpty ( field )

I want to perform a script that moves to a only records that are empty so I need to bypass records that already have entries.

 

Hi hownow,

 

Instead of stopping and checking the value in the field for each record, why not omit records you need to bypass first?  It may not work in this situation for you, but if it does, it would be faster than looping each record.  If you must loop, Comment's example is (no surprise) spot-on.   :-)

 

You can constrain the found set to empty records by using = in the field.

 

edited ... added word 'empty'

Edited March 12, 201510 yr by LaRetta

Thanks Comment

 

Thanks LaRetta    In my case with this situation it is not possible to omit. But the point is well taken for other circumstances.