I have an Access database that collects information from a web-based ASP collection form. How do I set a field (with data type is number or date) in my Access in a such a way it will accept a Null or empty string from a web form. I can make "No" on required, but what I have to do with Validation Rule? That is... I want users can still submit the rest of data and leave these fields blank in the collection form.

Note: I can do this with no problems with field of data type as text. Just the date and number data type which I have problems with.

If you specify required="no", you don't need to specify anything; just by not inserting anything into those fields will leave it null. Just test to see if the value is provided, and if not, don't do anything. You can specify an empty string for text fields, but null and empty string are two separate things.

I hope I understand the question right. If not, please let me know where I went wrong.

strSQL = "UPDATE myTable SET myField = NULL WHERE RecordID = 1"
objConn.Execute strSQL,,adCmdText+adExecuteNoRecords

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

hi kaytrina,

there is a very simply method , just follow :

1- Open you database then select your table.
2- after selected the table,press ( Design).
3- Select the field that you want to be null .
4- if the field is ( Text), select ( All zero length=yes)in the General Gategory.
5- if the field is ( Number), select ( default value =0).

Thanks

         ASP MAN


ali

Thanks for your tips, Ali... But what do I do with fields of data type Date.

Kaytrina

Hi Kaytrina,

Please take a look at this thread: http://p2p.wrox.com/topic.asp?TOPIC_ID=11015

It explains the difference between null and a zero length string, and digs a little deeper in the implications for your database.
For a date, you can use INSERT INTO MyTable (MyColumn) Values(null) as well.....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.