Setting check box

[Middlemarch]

I'm using a check box as a visual flag set by .visible property.
In design mode I see the tick, but when the Form opens the tick changes to a wee black square.
From Googling I'm told to set it's .Value property (NOT default value).
But nowhere in Properties list can I find Value. What gives ?? Or am i just blind?

[June7]

If by Properties list you mean the Property Sheet, Value will not list there. You have ControlSource property to bind to field or an expression. Use code (macro or VBA) to set a control's Value.

I am guessing this checkbox is not bound to yes/no field. If it were it would not show black square. Setting Value property of an unbound control will show the same value for all records.

Visible property only determines if control shows or is hidden. Has nothing to do with data.

[Micron]

If you go to a new record, box is always normally black. Once the record is saved it will be clear white if unchecked. At least that's how it works in tables. In forms I see a shaded box but it's more like a checkerboard shading.
Not all properties are in the property sheet.
https://learn.microsoft.com/en-us/of...checkbox.value

[June7]

Okay, correction, bound checkbox on NewRecord row is black/shaded when DefaultValue is not set. It will be clear and have value of False as soon as record entry is initiated.

[CJ_London]

checkboxes have three possible values - true, false and null (the black square). Null can only exist for unbound checkboxes and new records where the bound field does not have a default value (of 0 or -1). A yes/no field can only store 0 or -1 so as soon as you start to complete a new record where the yes/no fields does not have a default value the null value will be updated to 0.

checkbox controls (not fields) have a triple state property (normally set to no) which if set to yes enables a user to cycle through all three values - really only useful for unbound controls where perhaps a condition could have three values - for example a filter where you want to show all records where a condition is true or false - or use null to show both