[Resolved]ADODB: Invalid use of null

[vocalmind]

I had an error "invalid use of null". How to get away with this error?

[szlamany]

If it's on the VB side...

strValue = rs(0).Value & ""

or

text1.Text = rs(0).Value & ""

Concatenating an emptry string in VB will turn NULL into EMPTY strings. VB strings do not like null...

It can be done other ways - but that is the way we prefer in our shop.

[vocalmind]

This the code line. It means that if the postal code fields has no data on ACCESS it will prompt an error invalid use of NULL. I want that if the ACCESS has an empty fields then TEXT label is also empty.

txtPost.Text = rs.Fields("postal code")

[szlamany]

Then do this:

txtPost.Text = rs.Fields("postal code") & ""

The & "" will turn the database NULL value into an EMPTY string - which is what you say you want.

[vocalmind]

Thanks szlamany.

Phew...it's still along way to go.