Yes / No Field

[kevmeister]

Hi There,

Just want to know if this is possible:

I want to setup a simple yes/no field.

By default the field is ticked (default value = Yes)

In the records view, I can then un-tick the box.

BUT I AM NOT ALLOWED TO RE-TICK THE BOX, ONCE UN-TICKED, IT IS UN-TICKED FOREVER.

Is this possible, i was thinking of using validation, but it wont allow the default value to be used if I set validation to "No".

Is this possible?

Thanks

Kevin

 

[MajP]

set the default value to true.
Private Sub blnFld_BeforeUpdate(Cancel As Integer)
If Me.blnFld Then
DoCmd.CancelEvent
End If
End Sub

 

[kevmeister]

thanks that worked a treat.

cheers

kevin