Yes/No fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes/No field in Query 1
prevend dupes if 3
Count of Yes with repeating fields 3
Yes/No Fields 12
YES/NO Field 2
Access Table Yes / No Field Question 4
Yes/No field 1
Editing fields based on Yes/No field 6

Back
Top