How to filter out rows in a certain column by number of characters?

[kutlesh]

For safety I colored the rows in my picture, but you can call the columns whatever you like:



It happens that we import data into the Access table from Excel and some of the columns which should be formatted with 4 character places, contain only data in 3 places.

Without scrolling to the bottom of the table, how can I filter out rows in a certain column which contain less or more characters then the needed number of characters?

In this case rows with 3 chars, and it should be with 4.

[westconn1]

probably the easiest is to read the worksheet as a recorset, with an sql query

[Ecniv]

SELECT *
  FROM tablename
 WHERE LEN(tablename.fieldname) <> 4