Null Values

[casox]

Using VB6.0 and an Access database, I'm faced with the possibility of having a blank field which gives me a null value error. How can I solve this? I've tried putting "" as a default value but this doesn't work.

Thanks,

casox

[jpark]

You can check null value with IsNull(rsCustomer("Addr2")), or use Text1 = rsCustomer("Addr2") & "" to avoid null error.

Joon

[Clunietp]

If you want to allow a null value in your Access database, set the "ALLOW NULLS" property of the field to TRUE. You can do this in MS Access.

[compuGEEK]

form.txtField=format(rs("Field"))

Using this automatically changes a null to ""



------------------
CompuGEEK