Clearing a value from a textbox

[darkmage1]

I have a form that has a textbox names text42. If the correct value is entered into the box a tab page will appear. What I would like to do is when I am done with a record I would like the text42 field value to automatically clear when I advance to the next record.

Here is the code to get the tab page to appear. right now When the tab page is visible, the tab page stays visible for all records. I am using the OnCurrent Event with this code.

If Me!Text42 = 542865700 Then
Me.Page37.Visible = True
Else
Me.Page37.Visible = False
End If

 

[TheAceMan1]

How are ya darkmage1 . . .

In design view why not simply set the [blue]Default Value[/blue] property of [blue]Text42[/blue] to Null or an empty string ""

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[randy700]

At the point where you want the text box to be cleared, just add Me.Text42 = "". However, don't forget that, if this is a bound control, that value will be changed in your table.


Randy