Quick one for the experts!!

Hi,

I'm creating a front end for an Access2000 database.
When i create a recordset and then try to show the contents of the recordset on my form using:

lblHomePhone.Caption = !HomePhone

if the !HomePhone field in the database is blank it throws up an error.
How do i tell vb to ignore the blank field and carry on populating the rest of my form?

Thanks in advance

Mannyluk

Hi,

I'm creating a front end for an Access2000 database.
When i create a recordset and then try to show the contents of the recordset on my form using:

lblHomePhone.Caption = !HomePhone

if the !HomePhone field in the database is blank it throws up an error.
How do i tell vb to ignore the blank field and carry on populating the rest of my form?

Thanks in advance

Mannyluk


Use this

If IsNull(yourRecordset!HomePhone) = False THen lblHomePhone.Caption = yourRecordset!HomePhone

Thanks for that!!!

You sir !! are a star!