>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