Making text box controls visible and not visible in an Access 2003 report
Posted on 2011-05-10
I'm trying to make some text box controls visible or not visible under certain circumstances in a report using Access 2003 SP3. I have tried various combinations of the following code and also tried various event properties of both the report and detail section of the report. The best result has been to make controls for "Mod" visible but not those for "Low". The controls which are to be visible or not visible have their visible property set to "No".
If Me.txtTractIncSegmt.Value = "Low" Then
Me.txtLowIncNbrAppd.Visible = True
Me.txtHMDALowGoal.Visible = True
Me.txtLowIncPenetration.Visible = True
ElseIf Me.txtTractIncSegmt.Value = "Mod" Then
Me.txtModIncNbrAppd.Visible = True
Me.txtHMDAModGoal.Visible = True
Me.txtModIncPenetration.Visible = True
Any advice on how to solve this would be appreciated.