Clearing a textbox if its already empty

[sevanty7]

Hello
I currently have numerous textboxes on a form. I have a button called Clear
the code i've been using to clear my textboxes is the textbox.value = ""
for example for the textbox called description i have



description.value = ""

this works great when there is data in the textbox but there isn't anything it has a run time error. is there and "or" or "if" function i can run to stop this from happening?

Thanks for any help!

[Beetle]

What is your exact code (copy and paste here from your module) and what is the run time error message?

[sevanty7]

My current code is

FileID.Value = ""
Description.Value = ""
Process.Value = ""
Street_Num.Value = ""


However if a record were to have no value in the "Process" textbox for example the run time error will highlight the ".value" beside the word Process.

[Dal Jeanis]

What is the "Process" textbox bound to? When you get the error, bring up the immediate window and type

debug.print Me.Process.value

CHECK STEP ONE - About the time you type the second period, the programming interface should pop up Value as a suggestion for the property that you are looking for. If it does not do that, then there might be something wrong with the textbox itself - make a copy of the database, and in the test copy, delete that control and recreate it from scratch. See if that solves your problem.

CHECK STEP TWO - Hit enter and see what value you get. If you are dealing with a NULL, then you could try code something like

If Process.Value Is Not NULL then 
   Process.Value = ""
End if

CHECK STEP THREE - Review the field table to which the Process textbox is bound. Verify that the field in the table is set up to allow zero-length strings. If not, then add one space to the string that you are assigning.