Aug 7, 2002 #1 Survane MIS Joined Jul 3, 2002 Messages 74 Location US Is the code that will look at every txtbox on an open form and make the values null when a cmdbtn is pressed? Thanks.
Is the code that will look at every txtbox on an open form and make the values null when a cmdbtn is pressed? Thanks.
Aug 7, 2002 1 #2 gwinn7 Programmer Joined Feb 10, 2001 Messages 1,004 Location US 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+ Upvote 0 Downvote
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+