Check Checkbox

[Kate]

I have a filed defined as a checkbox. If it's checked then
what do I check the field for in my code? True and False?

 

[PC Datasheet]

If Me!NameOfCheckBox = True Then 'Checked = True
<<Do This>>
Else
<<Do That>>
End If

 

[Niklas Östergren]

Or you could just use:

If NameOfCheckBox Then 'Since a checkbox is boolean it´s true or false just
as it is.
' so by just checking the
checkbox status is the same thing
' as checking if it´s true or
false.
<<Do This>>
Else
<<Do That>>
End If


// Niklas

 

[Jeff Conrad]

Or you could just use:

If NameOfCheckBox

That's not recommended because it can introduce a bug in
Access. See:

http://www.mvps.org/access/bugs/bugs0005.htm
(Near the bottom of the page)

 

[Niklas Östergren]

Ok!
I din´t know that so now I have learn something new!

Thank´s for correcting me Jeff!

// Niklas