[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Clearing a text box bound to table without erasing data in that field

Posted on 2005-04-05
Medium Priority
Last Modified: 2009-07-29
I have a form with several text boxes that are bound to fields in a table.  When I first load the form I would like to have the boxes empty until someone selects a user id, from a combo box, to return records from the table. Also there may be times during normal operation when I would like to clear the information just to make the form more presentable.  At first I was setting the value property of the text box to = " ", but since the box's were bound to the table this was overwriting the information in that field.  Does anyone have a good way of clearing a text box bound to a table without erasing the info, or any other suggestions?
Question by:CanIJay
LVL 66

Accepted Solution

Jim Horn earned 200 total points
ID: 13710787
AFAIK it can't be done, as by definition a bound textbox displays the value that it is bound to.

What you can do is make them unbound, then populate them when the user selects a value.

Author Comment

ID: 13710888
That's what I figured I would end up doing, I just wanted to make sure there weren't any other way's without unbinding them.  


Featured Post

Independent Software Vendors: 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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

872 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