I have my sql field in ## marks for an update query written in VBA.
It works fine as long as the field is not blank. Unfortunately if the field is blank it equals null and gives me an error becauseof the #.
How do I avoid this
Code:
",tbl_instructor_dates.isdcw = #" & [Forms]![frm_instructor_misc_info_update]![ISDcw] & "# " & _
It works fine as long as the field is not blank. Unfortunately if the field is blank it equals null and gives me an error becauseof the #.
How do I avoid this