This topic is locked

Access database nulls vs zero length strings

7/26/2008 8:36:44 PM
ASPRunnerPro General questions
H
heets author

Hi,
I have several fields in an Access database that have traditionally contained null values. I am finding that whenever a record is edited or saved in ASPRunnerPro those fields now contain zero length strings. This is causing some problems with many existing queries that check for Null values.
Is there a way to have ASPRunnerPro save Null values in fields that are not filled on add and edit screens?
Thanks for your help,

Bruce

J
Jane 7/29/2008

Bruce,
use following code in the Before record added/updated event on the Events tab:

dict.Remove("FieldName")