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:
00591280
Views:
29
>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,"")
Igor Gelin
Database Developer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform