MS Access, Text Fields and Null.

[Zvoni]

Errr???

SELECT Id, SomeFields,
Iif(ProblematicField IS NULL, '', ProblematicField) As ProblematicField,
OtherFields......
FROM SomeTable

Or i'm missing the issue completely.....