Clear a Text Box with a button

[gheyman]

If you have a Textbox on a Form that is tied to Table, can you clear that Textbox by creating an event associated with a button?

 

[Joe4]

If the field is "bound" to a table, clearing that Textbox will remove that value from the table field for whatever record you are viewing at the time.

If that is what you want to do, simply add a button, and then add code to the Click event of the button that will remove it, i.e.

Private Sub Command23_Click()
    Me.TextBox1 = ""
End Sub

 

[gheyman]

What if you wanted to clear an entire column in a table (a Yes/No field). Button would rest them all to "No"

 

[Joe4]

You would probably want to use an Unbound for that, and have your your button run the code to do that.

An easy way would be to make an Update Query that does what you want (set the value of a field to blank).
And then just have your button run this Query.