Clearing textboxes

[dave8]

I have some textboxes on my form. There is a button to clear the textbox fields, e.g,

Controls("txtCity").value = ""
Controls("txtState").value = ""


Here's the problem: When I close the form (Unload userform1) and then bring it back up again, the values are still there. How to clear these fields permanently?

 

[Rick Rothstein]

If you put anything into the Text property of the TextBoxes at design time, in the Properies window, that text will always come back as the default text when the UserForm is loaded... so if that is what you did, then just clear that field in the Properties window for each TextBox. Another possibility is that you have VB code populating the TextBoxes somewhere.

 

[VoG]

If you have set the ControlSource property, the textbox will automatically display the associated cell's content.

 

[dave8]

My problem is that I can't seem to clear the textbox property. I don't have it populated any where else in the program. I have a piece of code that looks like this:

Controls("txtCity").text = ""

Does this clear the textbox property on my form? It seems to do it, but when I close the form (Unload userform) and call it back up, the data in the textboxes are still there. What can I do to explicitly clear the form fields?

 

[dave8]

Okay, I got it. I originally typed values in the textbox property for testing purposes. But I thought I can change the property text values in the code.

 

[Rick Rothstein]

Okay, I got it. I originally typed values in the textbox property for testing purposes. But I thought I can change the property text values in the code.

Something to keep in mind... VB code does not have any memory from previous executions. When you close a program down, if you did not store your values somewhere (worksheet cell, text file, etc.), then they are lost. If you do store them, then the first thing your code needs to do is read them back in and assign them wherever they are supposed to go. Again, VB code has no memory of prior executions.