checkbox question

[vbguy2008]

How do I test to see if a checkbox has been checked at run time?

[bren0098]

if checkbox_name.value = 0 then '...checkbox is not checked
if checkbox_name.value = 1 then '...checkbox is checked

[isnoend07]

You can also do:
if checkbox_name.value = VBChecked
if checkbox_name.value = VBUnchecked

[MartinLiss]

You can also do:
if checkbox_name.value = VBChecked
if checkbox_name.value = VBUnchecked

While that's the preferred way, you can also do

if checkbox_name.value = Checked
if checkbox_name.value = Unchecked

[isnoend07]

One other option to know about:
vbGrayed = disables the checkbox

[vbguy2008]

What will access 2003 accept as valid values for a yes/no field when using a SQL INSERT statement over an ADO Connection to send information to the table?

[isnoend07]

What will access 2003 accept as valid values for a yes/no field when using a SQL INSERT statement over an ADO Connection to send information to the table?

I'm not a database guy, but i think it would be true or false. Database person will probably give an answer

[si_the_geek]

It definitely supports the keywords True and False, eg: "...WHERE MyField = True"

It may also support the numeric values 1 and 0, and the strings Yes and No.