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:
00591279
Views:
22
>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

Kevin;

Try something like:
if not oRecSet.Fields("Mi").Value = null then
     txtMi.Text = oRecSet.Fields("Mi").Value
endif 
Tom
Previous
Reply
Map
View

Click here to load this message in the networking platform