Retrieving null values from Access db

[snorky]

I have a VB program that retrieves values from an Access db using the format

frm_main.lst_names.additem adorecordset!Names

If there is not an entry in the db the program fails on
94 - Invalid Use of Null
Do I HAVE to have an entry (even a dummy one ) to stop this or is there a simple way round it ( other than error trapping it ) ????

Snorkx :-9

 

[Sawatzky]

Dear snorkx,
try this:

frm_main.lst_names.additem iif(isnull(adorecordset!Names);"N/A";adorecordset!Names)

You can put into that string whatever you want.
but better would be probably not to add it to the list at all:
like this

if not isnull(adorecordset!Names) then
frm_main.lst_names.additem adorecordset!Names
end if


regards Astrid

 

[snorky]

Excellent - that covers what I needed - simple huh ? Thanx !
:-9

 

[Sawatzky]

dear snorky,

things that are known are allways simple. All the others are mostly really tricky.

pleased to have helped you

Regards Astrid