Invalid use of NULL

hi,
I hope someone finds this a simple problem and can provide a quick resolution....

I am creating a recordset from an Oracle DB. Then i am moving that data into labels on a form for viewing only by the user. the problem is when i encounter a field from the DB that is null the error comes up:
Invalid use of NULL - runtime error '94'.

is there a way to let the label just display a blank?

or do i have to ensure that the DB has no nulls in it? that seems kinda extreme to me.

hope you can help!

You should enforce No Nulls in any database anyway since you might understand tri-state logic, but I'll bet your users don't.

use: If IsNull(MyValue) Then MyValue = ""

Cheers,

P.

You could also place an empty string before the value retrieved from the database.

Code:

---

Label.Caption = "" & rs!SomeField

---