I want to use the Value property of fields to check if they are empty. The data comes from an Access table using ADO. I can do this happily with simple text fields by looking at the fields Value property. The problem field comes from memo data and is formated using the text interpretation set to RTF. If I test the field with the line:
If srptAnnualIndividualReviews_fldReviewText.Value = Null
I get correct information. The problem comes when I have a field that appears empty in the report but actually has RTF formatting. My method tells me it has text in but it is not readable text - just the RTF formatting information. The field's Value property seems to be empty all the time so I can not examine it in detail.
TIA Mike
If srptAnnualIndividualReviews_fldReviewText.Value = Null
I get correct information. The problem comes when I have a field that appears empty in the report but actually has RTF formatting. My method tells me it has text in but it is not readable text - just the RTF formatting information. The field's Value property seems to be empty all the time so I can not examine it in detail.
TIA Mike