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
Printable View
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
You can check null value with IsNull(rsCustomer("Addr2")), or use Text1 = rsCustomer("Addr2") & "" to avoid null error.
Joon
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.
form.txtField=format(rs("Field"))
Using this automatically changes a null to ""
------------------
CompuGEEK