Check Open Databases wizard message
David Thompson
dthmpsn1 at illinois.edu
Wed Jul 30 15:56:33 PDT 2008
> Thanks Jim,
> I went through and double-clicked every field in the
> data sheet...the only field which would not open was
> a field named Image which was a picture field. When
> I double clicked in that field it remained black and
> would not 'open.'
To view the contents of a picture field, you need to use a form with a data cell for that field. You can't do it in the data sheet.
> When I tried to do a Find/Select
> and designated the search to be that field greater
> than blank, I got a message that I could not use
> Picture column in an equation.
You can get around this restriction in a Formula Find/Select by searching for
sizeof("Image")>0
That way you are using the name of the field, rather than its content. The name is text, and you can use text in a formula.
Dave
More information about the Qna
mailing list