Yes/No fields

C

CurtainMary

Allen Browne MVP is his tips on the web highly recommends doing away with
Yes/No because the field cannot contain a Null. Thanks Allen !!
Occasionally Yes/No can still be alright but there can be a problem when
"filtering by form". Any tickboxes will have three states. 1)greyed out = not
applicable; 2)white = No and 3) tick showing = Yes.
 
W

Wayne-I-M

Hi

You could use an option group - set like this or with a number to set to a
hidden bound control.

Private Sub GroupName_AfterUpdate()
Select Case Me!GroupName
Case 1
Me.SomeOtherField = "Not Applic"
Case 2
Me.SomeOtherField = "Yes"
Case 3
Me.SomeOtherField = "No"
End Select
End Sub

or

Use a combo with 2 columns - the 2nd column (width 0) with values of 1,2,3
and use this as the bound column

Hope this helps
 
Top