Globally Check Contents Of Table

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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.
 
Back
Top