Making text box controls visible and not visible in an Access 2003 report
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.