checkbox on continuous form

[bobh]

Hi All,

In Access2003 I have a bound continuous form, one of the controls is a
checkbox. When a user opens the form I want to set the checkbox to
enabled = false for all the records displayed where the checkbox is
true. Conditional formating doesn't help me since it's not an option
for checkboxes.
So, can that be done with vba? or am I just blowing smoke here on a
Friday afternoon...
thanks
bobh.

[Phil]

Don't think so, but ....
Try creating a textbox same size as the check box - DummyCheckBox.
ControlSource is =Chr$(252) thats a tick in Wingdings. Set the ForeColour to
black. Set conditional formating of DummyCheckBox to if [MyTextBox] = True
set the forcolour to a Medium Grey - similar to disables checkbox colour.
Then superimpose MyCheckBox over DummyCheckBox (send DummyCheckBox to the
back)

On Current of the form you want
Private Sub Form_Current()
If MyTextBox = True Then
MyTextBox.Enabled = False
Else
MyTextBox.Enabled = True
End If
End Sub

It's as close as I can get - not perfect but it allows you to put a tick in
the unticked boxes, but not remove a tick from a ticked box. Might give you
an idea anyway

Phil

[Douglas J Steele]

Since whatever you do to one checkbox will affect all of them, essentially
the answer is no. However, since they can only interact with the current
row, does it really matter? Use the form's Current event to toggle the
Enabled property. It'll affect every row, but so what?

"bobh" wrote in message
news:2c92b7a2-4871-4a32...@a34g2000vbt.googlegroups.com...