Free text input to a form object

How can I create a form object to allow the user to input free text so I can later save it to a database table field?

Thanks

Glen
GPSPOWAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

PatHartmanCommented:
In an Access application forms are almost always bound and most controls on a form are bound.  That means that you don't actually have to do anything to make Access save the data.  Since you've never done this before, the simplest method is to let the wizard build you a form.  
From the Create Tab choose the Form Wizard and let it guide you.

To add an unbound text box to a form, switch the form to design view and choose the text box object from the ribbon.  Then "draw" it to put it somewhere on the form.  I circled the textbox object in the ribbon and underlined two controls.  One unbound and one bound.  The unbound control is not saved since you have not told Access where you want to put it.  You would need to add code to a form event to do something with the data if you wanted to save it.  The other control is bound and has a field name as its ControlSource.  Access will automatically fill this control when you move to a new record and save it if you change it.  NO CODE REQUIRED.
Form in design viewForm in design view
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
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.