Question about Yes/No selection buttons - can they be reset to "no choice"?

[D.M.]

Hi,
One of the people here at work has designed a database that students
will be using to enter data. She has Yes/No selection buttons, which
start out grayed out with no value. If a student selects the Yes or
No in error, is there any simple way to allow for the boxes to be
unchecked again to "no selection"? Any help will be appreciated.

Thanks,

Dan M.

[Allen Browne]

If the check box is unbound, you can:

a) Set its TripleState property to Yes. Now when you click the box, it will
cycle through yes, no, and null.

b) Programmatically assign Null to the check box, e.g.:
Me.[NameOfYourCheckBoxHere] = Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"D.M." <da*****@umich.edu> wrote in message
news:t9********************************@4ax.com...

Hi,
One of the people here at work has designed a database that students
will be using to enter data. She has Yes/No selection buttons, which
start out grayed out with no value. If a student selects the Yes or
No in error, is there any simple way to allow for the boxes to be
unchecked again to "no selection"? Any help will be appreciated.

Thanks,

Dan M.