If you are using Access, which allows a lot of VB functions to be used, you could try:
Code:
SELECT * FROM [Customer] WHERE Len([Customer_Num]) > 7
That assumes that you table is called "Customer", the filed your checking is called "Customer_Num", and you want all field from records from the Customer table where the length of the Customer_Num field is greater than 7

- gaffa