clear form

[vicgirl]

Hi,
Does anyone know if there is clear_form function to set all texboxes or combo boxes empty in Access? Thanks in advance!

 

[Crilen007]

Not that I know of.

 

[Ukraine82]

I'm not sure If I understand what you're saying, but if you want to clear a form than make a delete button.

Michael

 

[pbaldy]

How about:

  Dim MyForm As Form
  Dim ctl As Control
  Set MyForm = Screen.ActiveForm
  For Each ctl In MyForm.Controls  
    Select Case ctl.ControlType
      Case acTextBox, acComboBox
        ctl = Null
    End Select
  Next ctl