Form Code

[Phil C]

On a form with multiple text fields and a next command button what code would I need to clear each text box when the next command button is clicked on?

Thanks in advance

[John McGraw]

On 2002-04-30 13:14, Phil C wrote:
On a form with multiple text fields and a next command button what code would I need to clear each text box when the next command button is clicked on?

Thanks in advance

You just need to clear each one, one-by-one. So:

Private Sub NextButton_Click()

    Me.TextBox1.Value = ""

    Me.TextBox2.Value = ""

End Sub

Just do that for all your textboxes that you want cleared.

[ This Message was edited by: John McGraw on 2002-04-30 18:30 ]

[Ivan F Moala]

Or you could simply loop through each
textbox and cler it if you have a few eg

Dim tb As MSForms.TextBox

For Each tb In Me.Controls

    tb.Text = ""

Next

[Phil C]

Thankyou John
Works perfectly.