Querying field length

[Che3zy]

I have 2 tables. Table1 defines the permitted field lentghs for Table2

eg
Table1
NameOfField MaxLength
Field1 50
Field2 20
Field3 20
etc etc

Table2
Field1 Field2 Field3
Example 12345 54321

What I need to do is to query the data in Table2 to find any data that exceeds the maximum permitted field length and then shows which field is at fault.

There are more than 50 fields and hundreds of records, I'd like to avoid doing this manually...

Can anyone help?

 

[vbaInet]

Having 50 fields sounds like you have a normalisation problem. Can you show us a screenshot of these fields? i.e. a screenshot of the table in design view.

 

[Che3zy]

Attached. I am not validating data from Access, the data is "Fail" data from another system, I need to find which fields exceed the max length for that system. I then need to make an idiot proof form so I can hand it over