Click to See Complete Forum and Search --> : Enter a Null Value through DAO 3.6


slcotten
April 27th, 2001, 01:55 PM
Hi...
I have a database program in which I would like the user to be able to enter Null value. It doesn't absolutly have to be that way... I could intercept a request to enter a Null value and insert a single Chr(32) (space). Then translate as Null upon request for read. But I though it would be perhaps a little cleaner if I could just add Null value to database. Thanks for your help.

John G Duffy
April 27th, 2001, 04:55 PM
Don't know if it will work but try using the Constant "vbNull" instead of the space.

John G