Suppress RTF fields

[LFB]

crw 8.0.441
sqlserver 7.0
VB 6.0 sp 4
RDC
ADO
Convert Null to Default = True

Is there a way to suppress a section containing an RTF field? Eg I have a section that contains {ado.Notes}. I want to suppress it when it is empty, however, being an RTF field, as soon as a user enters the field in my application it is populated with the RTF code even though nothing was typed in. It is not possible to delete the contents of this field. As a result crw thinks that something is in the field and won't suppress it. In the 'format section' area I have ticked 'suppress blank section' and have a formula in the x-2 condition field for 'suppress' that says
trim({ado.Notes})=""
It don't work!

 

[FoxG]

Hi,

Is it not the case that the ado.Notes field does contain a specific string value when no value has been entered?

If you can identify the common feature then you could use a formula to select only those that do not match this.

Try displaying the field using '<'+{field}+'>' to see what it actually contains

or Try displaying length((field}) to determine what the length of an 'empty' RTF field is.

Geoff