I am finding it impossible in VBA code to set an initial value for an Access forms check box, that is, how the option box is to appear (checked or unchecked) when its parent form is Opened. My check box, which is not part of any option group, is otherwise working fine: As it is physically clicked, it is correctly passing True or False to its Me!CheckBox_Click event procedure.
Since I don’t know how the box is to appear until its parent form is to be opened, I cannot pre-fill its Default Value property at design time; I must do it in code. I initialize all controls (all unbound) in the forms Form_Open event procedure.
I’ve tried setting Me!CheckBox.DefaultValue to True, to “True”, and even to “=True”.
I’ve also tried setting Me!CheckBox.Value to True, to “True”, and again even to “=True”.
In all cases my code is ignored, and the check box is shown simply as grayed out. This all seems so simple; I’m following what the Help system is telling me to do. (I know, don’t get you started on that.) And I am having no trouble setting starting values to other kinds of controls (option groups, etc.) in that same Form_Load procedure.
Can someone please tell me how to do this?
Thank you,
John
