Clear Form Fields

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Does anyone know the VBA syntax or Access function to clear form fields in a
data entry form prior to adding a new record? The data entry form I have
created is quite long and I would like to give users the option of clearing
all their text and combo boxes with one click rather than highlighting each
and every value and deleting.

Thanks in advance for any help or advice you may be able to offer.

Nick C.
 
Thanks Jim, that worked. However, if the user clicks the button and then
closes the form, a blank record gets added automatically. Any way to
prevent this from happening?
 
Back
Top