Code To Make All Textboxes Null 1

[Survane]

Is the code that will look at every txtbox on an open form and make the values null when a cmdbtn is pressed?

Thanks.

 

[gwinn7]

Yeah, loop through the Controls collection of the form. Something like...

For each ctl in Me.Controls
If ctl.Type = <textbox> then
ctl = null
end if
next ctl

You will need to debug it, because it won't work as-is.

Gary
gwinn7
A+, Network+