For Each Control.... 2

[baileybelle]

I would like to clear the contents of each text box on a form using the 'For Each' command. what would the proper syntax be to accomplish this? Thanks in advance.

 

[craigsboyd]

Try something like this...

For lnCnt = 1 To THISFORM.ControlCount
loObj = THISFORM.Controls[lnCnt]
IF loObj.BaseClass = "Textbox"
loObj.value = ""
loObj.refresh()
endif
Next

...it should be noted that if your form has other controls that contain textboxes such as pageframes you would need to dig down into those and find the textboxes as well...but you didn't specify that so I am just giving the short and sweet answer for right now Slighthaze = NULL

 

[Mike Gagnon]

baileybelle

Here is a one-liner...

thisform.SetAll("value","","textbox&quot

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[craigsboyd]

Mike,

Here is a one-liner...

thisform.SetAll("value","","textbox&quot

Darn it, why didn't I think of that! Argggghhhh!! Slighthaze = NULL

 

[Walid]

This is just a clear answer for this question
Why we all here?
I personally think that we learn from each other maybe more than we help each other.

This was a good one Mick, will done


Walid Magd
Engwam@Hotmail.com