I am writing a databse program using an Access datbase in VB.

I am tryin to add the contents of a recordset to a combo box, however some of the values are NULL and so VB returns and error.

Therefore i am trying to convert the NULL to a blank string "" or 0 using an SQL statement

Code:
db.OpenRecordset("SELECT a, IIf(IsNull(a), "", a) " & _
                                    "FROM table")
This brings up a syntax error.... can NE one shed any light on this...

Ta