is there a command that resets the project? something that clears all text boxes ect.
Thanks
YT
Printable View
is there a command that resets the project? something that clears all text boxes ect.
Thanks
YT
In run-time? If so, you can do a loop:Code:Dim frm As Form
Dim ctl As Control
For Each frm In Forms
For Each ctl In frm.Controls
If TypeOf ctl Is TextBox Then
ctl.Text = vbNullString
ElseIf TypeOf ctl Is Label Then
ctl.Caption = vbNullString
Else
'...
End If
Next
Next
thats done it, thanks heaps
You're welcome :wave: