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!