Subreport Trouble

[John]

I have a report with a conditional IIf statement that if a value is empty a
message is displayed stating as such. When run by itself it works fine. I
have then placed this as a subreport on another report. When run, if data is
available everything looks OK, but if the specified value is empty the
message is not displayed. Why does it work as a report but not a subreport?

 

[KARL DEWEY]

f a value is empty a message is displayed stating as such.
Are you evaluating for a Null or zero length string? There is a difference.

 

[John]

The subreport is evaluating for a zero length string.

 

[Douglas J. Steele]

If there's no data on the subreport, you can't check for either a
zero-length string or a Null value. There's nothing to check!