Check Boxes

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

This is probably going to be a really silly one but anyway .....

I find it really easy to accidentally change a check box value without
noticing. Is there anyway to require confirmation of such changes? I realise
that could also be a pain, but just wondering.

Regards.
Bill.
 
Bill said:
Hi All,

This is probably going to be a really silly one but anyway .....

I find it really easy to accidentally change a check box value without
noticing. Is there anyway to require confirmation of such changes? I
realise that could also be a pain, but just wondering.

Regards.
Bill.
Click to expand...


You could do something like this in the Before Update event ...

Private Sub Check0_BeforeUpdate(Cancel As Integer)
If MsgBox("Are you sure?", vbYesNo Or vbQuestion) = vbNo Then
Cancel = True
End If
End Sub

Alternatively, use a combo box instead. Set the row source type to Value
List, the row source to -1;Yes;0;No, the column count to 2, and the width of
the first column to zero.
 
You could do something like this in the Before Update event ...
Private Sub Check0_BeforeUpdate(Cancel As Integer)
If MsgBox("Are you sure?", vbYesNo Or vbQuestion) = vbNo Then
Cancel = True
End If
End Sub

Alternatively, use a combo box instead. Set the row source type to Value
List, the row source to -1;Yes;0;No, the column count to 2, and the width
of the first column to zero.
Click to expand...

Thanks.
 
Back
Top