Adding a customized text box in a report (1 Viewer)

[mrssevans]

I am building a report where I need to have customized text boxes appear if an item in another field is shown.

For example
These are service agreements and if the sales person checks "runners" to appear on the agreement then I also need a text box with a prewritten disclaimer to appear on the agreement. Can someone help? Thanks

 

[Rich]

Is the disclaimer text stored, if so add a text box to the report you can use DLookUp on the table field as the record source. Then just switch the visibility of the control depending on the condition that controls the other text box visibility.
In the OnFormat event
If Me.SomeTxtFld = True Then
Me.NewField.Visible=True
Else
Me.NewField.Visible = False
End If
where SomeTxtFld is the check box "runners"

 

[mrssevans]

The disclaimers aren't stored but can be very easily and would probably be a lot easier. Thanks for the help, this is what I was looking for.

 

[mrssevans]

While setting this up I came across another question.

The check boxes are not what is called runners, there is a field called "setup item" and it is a combo box. What I need is if "Setup Item" = runners then make the box visible. How do I alter the code above to do this. Thanks