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

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?
CanIJayAsked:
Who is Participating?
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
0
 
CanIJayAuthor Commented:
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.  

thanks
-Jason
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.