Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Help With ADO
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00591211
Message ID:
00591287
Views:
28
>>I have a method called ShowFieldValues on my form, which contains:
>>
>>
>> txtMi.Text = oRecSet.Fields("Mi").Value
>>

>>
>>and when I run it, I get the error"
>>
>>"Invalid use of null"
>>
>>Now I already know there is no data in this field, but that is ok in this
>>app. So how do I tell Access that Null's are ok?
>>
>>Thanks
>
>Try:
>
txtMi.Text = NZ(oRecSet.Fields("Mi").Value,"")
>
NZ comes from Oracle and is not recognize by VB. The shortest workaround is:
txtMi.Text = oRecSet.Fields("Mi").Value & ""
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform