Reset Controls on Form

[VTbigwillie]

Is there a way to reset all of the values on a form without setting the focus on each of the controls?

Along a similiar line, is there a way to check all of the controls to make sure data is in them w/o setting the focus?

Thanks in advance,
Will

 

[scking]

Me.Undo will reset all values

Me.Dirty only checks that there has been a single value modified from the new record

As far as I know there is no way to check that each control has a value by using intrinsic functions. It would be very easy to write a routine such as:

Public Function DoAllControlsHaveData() As Boolean

Dim bYes As Boolean
bYes = (Len(Me.txtVal)) > 0)
bYes = (Len(Me.txtVal2)) > 0
...
DoAllControlsHaveData = bYes

End Function ----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------