if Trim( myNumberField) = "" then myNumberField="0"
or you can set the default value to 0 in your MDB and only INSERT if <> ""
if Trim( myNumberField) <> "" then sqlTxt = sqlTxt & ", " & myNumberField
"Targa" <targa1SPAMSalltel.net> schreef in bericht
news:%23C71lDZNEHA.2488TK2MSFTNGP10.phx.gbl...> Ive got a form that posts to an Access db and a few of the fields are of
> "number" type in the database.
> These fields do not require data to submit the form but if they are
> submitted empty, I get "Syntax error in INSERT INTO statement".
> Is there any way around this other than giving the fields a default value?