If statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a check box that is true if another text box contains
anything > than "a". But I want it to be false if that text box contains
"Expired".
How would I write that and where?

Thanks
 
Reword whichever statement is enforcing the > "a" to include ' and <>
"Expired" '
 
Dar,

You could use the text boxes afterupdate event, something like:

Private sub txt_YourTextBox_AfterUpdate

me.chk_YourCheckBox = (me.txt_YourTextBox) > "a") AND _
(me.txt_YourTextBox <> "Expired")

End sub

HTH
Dale
 
Back
Top