Collect data

Experts, I have setup a form to collect data.  It seems to work well and the responses are logged in the DB.  

I have a field for Yes, no, maybe and the way the contact is to anwer is a little confusing because it asks the contact to "type the number that corresponds to the value you want" and there is a hyperlink to the bottom of the email that says "in the list below type the number that corresponds to the value you want". Ie 1 = yes, 2= no

How can I avoid this and just simply have yes or no or maybe as the choice for the contact I/o having to type the corresponding number?

Thank you
pdvsaProject financeAsked:
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're using the Data Collection feature of Access, then you can't do anything with that Outlook email that's generated. You're stuck with using it as-is, or using alternative methods to capture data.

Also, be aware the Data Collection feature was removed from 2013, with no plans for a replacement feature:

I tried to implement this for a couple of customers, and in each case we ended up using other methods - in a few we created Excel spreadsheets and attached them to the email, and in a few others we ended up creating web pages where users could enter the necessary data.  Both of those methods were far, far more reliable that Data Collection. IMO, it was a feature that was rolled out far too early, and had far too many gaps and inconsistencies.
pdvsaProject financeAuthor Commented:
here is the pic in outlook that shows what the contact receives. See circled areas

pdvsaProject financeAuthor Commented:
the field "Answer" is a combo box with row source of "Yes";"No";"Maybe".
pdvsaProject financeAuthor Commented:
Thank you Scott.  I think I will reconsider.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.