pdvsa
asked on
turn on Lable visible property for criteria
Experts, I have a form with a subform linked by LetterOfCreditID;ProjectID .
I have a lblExpired that I want to appear for when me.expiredYN = Yes but the lbl is only suppose to turn on for that particular record and not the others. For example, there are 5 records on the subform and 2 of them are [ExpiredYN] = Yes then turn on the lblExpired for only those two records.
With the code I have now, the lblExpired stays on for all the records when [expiredYN] = Yes
How can I make the lblExpired turn on for when [ExpiredYN] = Yes but for only those records? (ExpiredYN is a true YN field. with name cboExpired) lblExpired has its visible property = False
Private Sub Form_Current()
If Me.ExpiredYN = 1 Then
Me.lblExpired.Visible = True
End If
thank you
I have a lblExpired that I want to appear for when me.expiredYN = Yes but the lbl is only suppose to turn on for that particular record and not the others. For example, there are 5 records on the subform and 2 of them are [ExpiredYN] = Yes then turn on the lblExpired for only those two records.
With the code I have now, the lblExpired stays on for all the records when [expiredYN] = Yes
How can I make the lblExpired turn on for when [ExpiredYN] = Yes but for only those records? (ExpiredYN is a true YN field. with name cboExpired) lblExpired has its visible property = False
Private Sub Form_Current()
If Me.ExpiredYN = 1 Then
Me.lblExpired.Visible = True
End If
thank you
What version of MS Access are you using?
Versions 2007 and 2010 have conditional formatting for some controls (text boxes and combo boxes for instance) that you may find useful.
Conditional formatting for a form in design mode is found 'Form Design Tools' > 'Format'
J.
Versions 2007 and 2010 have conditional formatting for some controls (text boxes and combo boxes for instance) that you may find useful.
Conditional formatting for a form in design mode is found 'Form Design Tools' > 'Format'
J.
ASKER
Dockieboy: yes, it is continous. the lable is unbound.
JAMCO: not certain if you can turn on the visible property through conditional formatting.
JAMCO: not certain if you can turn on the visible property through conditional formatting.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh yes... The text box trick. I remember this now. I think i should be fine with your idea now.
Thank you
Thank you
ASKER
that worked great! thanks...
Welcome
Couple of questions.
Is the subform a continuos form? (I'm guessing that is is, just want to be sure)
Is the label bound or unbound?