the best piece of code for new users 4

[thefox149]

Just wanted to start a thread helping the new users out their

The best piece of code i ever learnt was the loop thru of controls on a form if only i had know it 6 databases ago....I use this so much and has been the best peice of code for me

EG

For Each ctl In (MyformName).Controls
If TypeOf ctl Is TextBox Or TypeOf ctl Is ListBox Then
With ctl
.Value = Null
End With
End If
Next

 

[ZmrAbdulla]

Dig more on this with RoyVidar's FAQ

Form - looping thru the controls faq702-5010

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.