Clear Form Fields

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.
 
N

Nick

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0
Copy previous record into form field 0
Data entry for a table from a form 1
Clear all fields in a form 3
Data form 0
If datapoint already exists populate form 2
How to clear the previous data 3

Top