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