If the report is based on a table, you will have to filter it to exclude records where the checkbox is True or -1.
If it's based on a query, modify the query criteria to do the same.
If the 4th row values are related to the 3rd, wouldn't indenting them make it more obvious that they are related (are child records)? I ask because row 2 is greatly indented and doesn't have a checkbox. Row 3 isn't indented (same as row 1 and 3) yet it doesn't have a checkbox. So my answer is based on my interpretation of what's presented.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Micron,
So it is a report based on a query.
I am not sure on how to get Access to only show the details if the Individual Issue Yes/No Field is unchecked.
So in the below example from the report, I want the details section below the Pistols to be empty because the yes/no field is checked, while I want the details section below the Radio set to be populated as the yes/no field is uncheck.
Hope you can help as I am hitting a wall.
thank you
Code in group header OnFormat event can conditionally display the Detail section. OnFormat events only trigger in PrintPreview or direct to printer.
Me.Detail = Not Me.[yes/no field name]
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Can be a one-liner
Me.Detail = Not Me.Text182
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ooops, thanks for the catch, Paul.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.