[AccessD] Insert Into with Null Fields

Dan, just in case -- that placeholder -- '' is two single quotation marks, 
not one double quotation mark. I should've mentioned before.

Susan H.


> Thanks Susan!
>
> I'll try this out.
>
> Dan
>
> INSERT INTO doesn't care if a value doesn't exist, it only cares about the
> placeholder. When txtA is empty, insert a zero-length string.
>
> If IsNull(txtA) then txtA = ''
>
> Stg = "INSERT INTO tblMain ( A, B, C )" _
> & " VALUES ('" & txtA & "', '" & txtB & "', '" & txtC & "')"
>
> Susan H.