>>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