Checkboxes in a Form

[Denise]

I want to have a checkbox automatically be checked in my form when it opens
up. I.E., Yes (Check if yes) No (Check if no) N/A Show up checked

So I don't have to click all of the N/A in the questions if it doesn't apply.

Thanks.

 

[Kenny G]

In your form area in the properties area the default value should be -1

All new records will be checked. The user would have to click the area to
uncheck the field.

 

[John W. Vinson]

I want to have a checkbox automatically be checked in my form when it opens
up. I.E., Yes (Check if yes) No (Check if no) N/A Show up checked

So I don't have to click all of the N/A in the questions if it doesn't apply.

Thanks.

What's the structure of your Table? If it has these three fields, your table
structure isn't properly normalized: you could have a record that has ALL
THREE fields True, or none at all!

I'd suggest instead having ONE field, Integer datatype, with values 1 = Yes, 2
= No, and 3 = N/A. Put an Option Group control on the form with a default
value of 3 and these three options, and make the field required in your table.