Try this as an auto-enter formula:
IsEmpty ( FilterValues ( ValueListItems ( "" ; "yourVLname" ) ; self ) ) ;
"your substitution value" ;
To process your existing data, apply the same formula using Replace Field Contents. Create a backup before you do – there's no Undo with RFC.
Thank you for your creativity. Would never have thought of this. WIll set up later this week and keep fingers crossed.
Again, with appreciation ... this one has had me stumped for ages.
Hello, a quick note. Took your suggestion on, tried to get it to work, but must be missing something or just can't see my error. Had many, many thumbs downs trying.
Got me stumped ... how can something seemingly so simple be so difficult to get working?
Scatching my head!
Regards .. AA