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

Posted on 2005-04-05
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 65

    Accepted Solution

    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

    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.  


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    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…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now