checkbox validation and conditional formatting 1

[jeffshex]

Hey all.
Are checkboxes weird with VB Programming?
I have a statement that is like this:

On click event of checkbox

If me.checkbox.value = 1 then
me.text1.locked = false
else
me.text1.value = ""
me.text1.locked = true
end if

Basically, until the checkbox is checked, the user cannot enter information into text1. Once the box is Unchecked, it clears the textbox and locks it.

Seems that the IF statements make it NOT work.
I also use the form current event to check and make sure the checkbox is unchecked (and if it is it locks the text1 textbox.

Anybody have any advice or anything?

 

[PHV]

If me.checkbox.value then


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RoyVidar]

This is a forms question ([ignore]forum702[/ignore])

You might find using the after update event of the checkbox control in stead of the on click event to work better, in addition to the on current event of the form. True in VB(A) = -1, so check like demonstrated by PHV or against True/-1.

Roy-Vidar

 

[jeffshex]

Right on!
That's what I needed to know Roy.
Thanks so much!

-Jeff