Hi,
Getting the above error message. My form submits data to access 2000 table. Some of the forms input isn't required to register (such as the 'mbrAdress1' field) so I want to be able to submit only the data required and for the user to skip this field if they want.

Can someone advise me how to do this?

Thanks in advance.

You have to set the "Allow zero string" to "YES" in the fieldname (Access)