Hi,

Can anyone help me with this problem?

I am populating a form from a SQL Server database. Some of the columns from the database are NULL and I need to show all the info from the database.

The form can then be updated. (NULL values may be written back.

Problem is when I'm assigning my textboxes their values. If the value is NULL I get the error message - invalid use of NULL. I've tried checking to see if the value is null before the assignment but nothing seems to work

e.g.
me.txtAddress = !address
me.txtPhone = !phonenumber

as I said putting if statements round them to trap the NULL values doesn't work.

Any ideas?

H.