Full Version: Clear Detail section if criteria is met
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
CurlieQ1034
OK, on a report, I am displaying book, pages, and entry #s from a courthouse land book. I have no problem displaying that. Yet, I don't want to show that information when a certain box is checked. When it's checked, I want to show some notes. How do I NOT show or hide the info. in the detail section and only show the notes?

All I can think of is put IIF statements like this one:

CODE
=IIf(Not (IsNull([CkBox])),"","Label:")
CurlieQ1034
Oh, also, I thought of hiding the detil section in the On Format property. Yet, I don't know how to show the notes that way...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.