How to design report for invisibel some text box in print out

[deepaksharma]

I have a form which contains some text boxes. While designing the report, I have coded in the report_page that if the value in the text box named txt1 is true then its data and a special label located in the report should be shown in the print preview, otherwise not. And In the text box and label properties I have them set to invisible. This is working properly when the value of text box is false then its data and label is not shown in print view but the problem is coming that text box' value and label is visible on printout. How to solve this problem? I think there is something wrong with printing multi print (like multi invoice).


Thank you.

[Bob Fitz]

....I have coded in the report_page .....

Show us your code.

[ranman256]

in ON PRINT event:

txt1.visible = not isnull(txt1)

[deepaksharma]

Show us your code.

Private Sub Report_Page()


If Me.txt1.Value = True Then
Me.Label97.Visible = True
Me.Revise_Date.Visible = True


End If

in the table txt1 data field type is set to yes/no