Solved

Free text input to a form object

Posted on 2014-10-15
1
245 Views
Last Modified: 2014-10-15
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
Comment
Question by:GPSPOW
1 Comment
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40382465
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question