Invalid use of <Null> Error Numger 94

[Edward Wittlinger]

In Visual Basic I have an adoRecordset and I have all unbound controls. When
I run the application I get the error message Invalid use of Null Error number
94 if all the records had data then the program would run fine but couse
there is null values the program fails. HELP...

Edward Wittlinger

[Keith]

Before doing anything with the recordset check if it has data using

If not (rs.bof and rs.eof) then
...

"Edward Wittlinger" <Nautica216@yahoo.com> wrote:
>
>In Visual Basic I have an adoRecordset and I have all unbound controls.
When
>I run the application I get the error message Invalid use of Null Error
number
>94 if all the records had data then the program would run fine but couse
>there is null values the program fails. HELP...
>
>Edward Wittlinger

[DaveSatz]

only variant variables can hold NULL's in VB.
--

HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
-----------------------------------------------------------------

"Edward Wittlinger" <Nautica216@yahoo.com> wrote in message
news:3c0bdf98$1@147.208.176.211...
>
> In Visual Basic I have an adoRecordset and I have all unbound controls.
When
> I run the application I get the error message Invalid use of Null Error
number
> 94 if all the records had data then the program would run fine but couse
> there is null values the program fails. HELP...
>
> Edward Wittlinger