Clear Fields Button

[manners]

Can anyone help me to create a "Clear Fields" Button on a form please?

 

[aqif]

Write the code like:

Me.Txtbox1=Null
Me.Txtbox2=Null

I believe that u've to clear each field by mentioning the name of every field in the code.

Cheers!
Aqif

 

[SteveA]

You could also write code to loop through the controls collection. ie

Dim ctl as control

For each ctl in Me.Controls
If ctl.ControlType = acTextBox then
ctl.Value = Null
end if
Next ctl

Cheers,
SteveA