Working with null values 1

[TanyaSealey]

I'm currently building a SQL Server database, with an Access 2000 front-end. I've set all numeric fields to not Allow Nulls, and I've set default values to 0. I want to control null values in the Access forms, so that when the user enters a null value a before- or afterupdate event procedure converts it to 0. However before any event runs (afterupdate, beforeupdate, change etc) I get the following error message: You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162). Does anyone know how I prevent this message from appearing?

Thank you.

 

[tlbroadbent]

Post your question in forum702 - Microsoft: Access Forms. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[Dale3]

I don't know if you would like this solution, but have you considered allowing nulls in the table but effectively prohibiting them with the forms controls you are already implementing?

If this wouldn't be satisfactory, then how about making the forms not be a direct update to the to the database, but instead to a temporary table for data entry purposes only. Then when the record is complete, completion of the entry form would start the event to go ahead and update the actual table from the temporary table and delete the temporary table entry(ies).

Dale3