Subreport Trouble

J

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?
 
K

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.
 
D

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top