invalid use of null

[mxp]

i am trying to get data out of a databse using vba and i am getting a runtime error '94' - invlaid use of null.

i am trying to access the value in the database in the contact column using the below code

Please Login or Register  to view this content.

and it is this line that is causing the problems. There is no value stored in the database for this field when returned for the specific row and unfortunately the nature of the project is such that i cannot always guarantee an entry in that field. how can i extract the value for the contract field (even when it is empty) so that i dont get this runtime error?

any help much appreciated.

mxp

[mudraker]

I am no expert at extrating info from a database.

Perhaps test for null 1st

Please Login or Register  to view this content.

[antoka05]

You can try to filter with isnull instruction:

Please Login or Register  to view this content.

Regards,
Antonio