Globally Check Contents Of Table

[Tom]

I have linked to an Excel spreadsheet with 15 columns. The cells in the
worksheet should only contain a cap X or be blank. Lowercase x is also
acceptable. ("" is not acceptable) Is there a way to globally check the entire
linked table to see if there is anything else but an X, x or blank in any cell
in the table or does this need to be done column by column?

Thanks!

Tom

[Wayne Morgan]

The manual find in Access (the one you get when clicking the binoculars button on the
toolbar) has the option to search an entire form or table for an item. To do it from code,
you would need to do a FindFirst/FindNext on each column.

--
Wayne Morgan
"Tom" <th*******@bellsouth.net> wrote in message
news:aU*****************@newsread1.news.atl.earthl ink.net...

I have linked to an Excel spreadsheet with 15 columns. The cells in the
worksheet should only contain a cap X or be blank. Lowercase x is also
acceptable. ("" is not acceptable) Is there a way to globally check the entire
linked table to see if there is anything else but an X, x or blank in any cell
in the table or does this need to be done column by column?