Solved

Free text input to a form object

Posted on 2014-10-15
1
247 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 36

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

Technology Partners: 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!

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

726 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