Solved

Free text input to a form object

Posted on 2014-10-15
1
244 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

777 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