Clear screen Help

[Guest]

I have a three text boxes and i want to delete its content using a command
button,i use the command in the command button like this.....
Text1.text = " "
Text2.text = " "
Text3.text = " "
and when i click the clear screen button that i have made,a debug screen
appears..i try some changes in the code, but nothing happens.Please
help..thanks

 

[Al Campagna]

Renato,
Whenever you get a "Debug" screen, you should indicate what that error was, and what
line of code the Debug pointed to.
Your really not clearing those text fields with your code... your putting a text space
in each of them... which is not the same as "clearing."
Try... (assuming the text controls are text, and not numeric)
Text1 = Null
Text2 = Null etc...
The Text property requires that the control have the focus when the Text value is
updated. Check Help on Text Property...
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."