MS Access, Text Fields and Null.

[Zvoni]

I don't understand what you are referring to:

If IsNull(rsDataSet.Fields(0)) Then
   txtWhatever.Text = ""
Else
   txtWhatever.Text = rsDataSet.Fields(0)
End If

This won't suddenly crash. It's clean and it's obvious how the special case IsNull is handled.
If you have multiple columns in table which are allowed to be NULL then you have to deal with this in your code.
I really don't see the problem.

Or use the IIF in the SELECT-Statement, then it doesn't matter.
Consequence: He has to fully formulate his SELECT-Statements.
No "lazy" way with "SELECT * FROM"

If OP doesn't want to change away from the "SELECT * FROM" then i'm done with him. Then he's on his own.....