Tutorials
Allow blank entries in Access
The first thing you need to know is that there is nothing wrong with your form! (In all likelyhood :)
The majority (96.83%) of the time, the problem is at the database end of things.
For the purposes of this tutorial, I'm going to use an Access Database as an example.
The principle remains the same for whichever database you choose to work with.
You need to find the Allow Zero Length field for the columns in your database that are not necessary for the user to fill in details for on your web page form. (Highlighted on the image below)

Once you have identified those columns that are not required - set the Allow Zero Length property to Yes (Also make sure that Required [above it] is set to No).
© Copyright 2008 - robgt.com

