Deleting inadvertent entry in Yes/No option group 1

[dfwelch]

I am creating a data entry form for clericals to use to enter data from a survey I am administering. Most of the questions are Yes/No, and I've created option groups that have two options, Yes or No. The data entered for each form goes into a table that contains just survey response information for surveys that have been received.

I want to be able to track those surveys where no answer is given for any Yes/No question, so there is no default value in the field definitions in my table. This means that on the form, neither Yes or No is selected by default, which is perfect. My problem is this:

I know there will be times when a data entry clerk inadvertently selects Yes or No on a question that has not been entered, and I cannot find a way for them to undo it. In other words, once they've decided to select Yes or No, there is no way (short of going into the data table and deleting the inadvertent entry) for the clerk to return that data field to an empty state. Here's what I've considered:

I could probably solve the problem by having a three-state option group, but for several reasons I would rather not have to do that. I thought I might be able to set an OnDoubleClick event to set the field back to Null, but that did not seem to work either. Any suggestions anyone?

 

[dfwelch]

Never mind folks. I was able to get the DoubleClick deal to work!

 

[khwaja]

I have a same issue but don'y know what you meant in your note by Double Clikck deal. Can you please explain?

Cheers

AK

Note: Using Access 97 - still.

 

[dfwelch]

Sorry for the delay in response. I just got back from vacation. What I meant by double click deal is when I double click any part of the Yes/No field, the field value is reset to Null (no answer).

Follow these steps to accomplish this:
1. Go to the properties of the field.
2. Click the Event tab.
3. Click your cursor into the "On Dbl Click" field.
4. Click the ... key to the right, the double click Code Builder.
5. The line I entered for code was [3F].Value = Null. "3F" was the name of the form element I was working with. Not the name of the Control Source (field name in the table) but the name of the element in the form. That is under the Other tab in the properties.

 

[randy700]

However, in order to properly use the "double click deal", your users will need to know of it's availability.

Another method would be to add a button that reads something like "Clear Entry" next to the option group. In the code for the button's click event, set the option group value to 0.

Or, change your option buttons to check boxes where the user can select/deselect. You can include code behind the check boxes to prevent both yes and no from being selected at the same time.


Randy