Check if the Rich Text Field is empty or not
Posted on 2006-06-06
If doc.Attachment(0)="" Then
I've always used the above line to check if a field is filled in or not.
For Rich Text Field it doesn't work because I get an error "Variant doesn't contain a container"
I tried to check it with a Formula like @IsNull or @Contains but I didn't succeed.
@Attachments isn't good either, because there're more attachment fields but only one is required. If @Attachments returns 1, then I don't know if the required field is filled in or the user attached a file to another field which isn't required.