Globally Check Contents Of Table

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
 
J

Jen

Hi,

How about putting the data validation on the excel
spreadsheet instead of having to code this through
access? Is this an option for you?

Regards,
Jen
 
W

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