Prevent printing a field if checked NO on query form

E

ET Sherman

Since the ContractAmt field in your record source query is
bound to a control on the report you should leave it in
the record source.

Try using the Visible property of the ContractAmt field on
the report as shown below:

In the On Format event of the Detail section of the report
add this:

If [Forms]![YourFormName]![YourCheckBox] = False Then
Me![ContractAmt].Visible = False
Else
Me![ContractAmt].Visible = True
End If

Regards,

ET Sherman
 

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

Similar Threads

Detail_Format works in Print Preview but Not When Printing 0
How make a control conditionally invisible? 2
Show Label & Text Box in Report based on Checkbox 3
Using VBA to hide a report's detail section? 1
control on form from report 3
Reports and Events 3
Trying to control when a line is displayed in a report. 8
Accessing Fields on a Report 2

Top