Hi All..
I have 18 Labels and 1 Text box on my report. All of which the 'Visible' Property has been set to 'No'.
The text box will always contain a numerical number ranging between 1 to 99. Each Label represents either a single digit value (ie. 1) or 2 labels for a double digit number (ie 15).
On the 'On Format' event, I have code written to make the corresponding label(s) visible pending on the value in the numerical text box.. example code:
If Me.Event_Number = 1 Or Me.Event_Number = 11 Or Me.Event_Number = 21 Or Me.Event_Number = 31 Or Me.Event_Number = 41 Or Me.Event_Number = 51 Or Me.Event_Number = 61 Or Me.Event_Number = 71 Or Me.Event_Number = 81 Or Me.Event_Number = 91 Then Me.Event1.Visible = True
End If
I assumed that after each record in my table that is associated to the report was displayed with the proper 1-2 labels, that the 'Visible' property for all 18 labels would reset back to 'No'. But they don't.. They remain visible in which their visible labels affect the next record displayed in the report causing an ongoing effect. See screen shot.
so my question is this. What do I need to do so that only the specific labels related to the text box are only lit for each record that is displayed in the report?
thanks
tom