I have two text boxes on a report and would like to control which one is visible based on a value in another field. I can accomplish what I want in Print Preview by using VBA:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [TPR_Multplier] > "1" Then...