Amanda,
Thank you SO much.
>>Jose,
>>
>>How can I work with the bookmarks if the field is empty?
>>In other words, if I have a bookmark inserted, 'hazard' and
>>it is empty, I'd like it to say 'None'. Also, there is a
>>situation where I could have three or more 'hazards', if I
>>just insert the 3 possible bookmarks, I'd like the first to
>>be 'None' and the second and third bookmark to be empty or
>>show nothing. Follow me?
>>
>
>PMFJI, but I had the same problem a few months back. The code I used to determine empty fields was:
>
>IF EMPTY(hazard)
> .APPLICATION.SELECTION.DELETE
>ELSE
> .bookmarks("hazard").RANGE.TEXT = "none"
>ENDIF
>
>Hope this helps!
"Live Well, Laugh Often, Love Much..."