Replace text in text box with user input, but not add to database if no change ACCESS 2010 form

I have inherited a database with two survey forms, one has 32 questions the other has over 50.  The two forms correspond with a paper survey the user fills out, then gives to the data entry person and they just follow by the question numbers.  However, there is no way the user can be sure they are on the correct data entry box.  Is there a way to have as the text the question and when the user enters the data, that is what is recorded, but I do not want to record the question text.  I was thinking that when the user enters data, the font color would change so they would know which box was populated with data, but what would be a good approach to tell the database to enter into the table only those fields that were updated?  This would be, of course, an unbound form to start with.
Sandra SmithRetiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Why not use a standard Label to show the question text?

You'd have to store the Question Text in a table and retrieve it when the form is loaded, of course. From there, you could perhaps use the Textbox's Tag data to determine the question "number", and then use standard SQL statements to insert/update, based on what the user enters.

Why are you doing this unbound? This is tailor-made for a bound form ...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sandra SmithRetiredAuthor Commented:
I inherited this and the customer does not want text labels, I asked that first thing. they want as few changes as possible and are used to doing it this way.  Actually, I changed my mind and am leaving it as a bound form.  Your suggestion does solve my problem with minimal changes to the form so the user does not get confused.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.