Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
GPSPOW
Asked:
GPSPOW
1 Solution
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now