hello comp.database.ms-access,

is there a way to use the InputMask property to validate
something going into a table from another table using vba?

i.e.,

table2 already has a telephone field:

table2
ID Telephone
1 555-555-5555
2 555-5555
3 555-5555-555

table1.Fields("Telephone").Properties("InputMask") = "(000) 000-0000"

now i want to move the data from table2 to table1 and check that
the data in table2 will fit into table1, if not i want to fail it
and move on to the next one.

only record 1 from table2 should pass.

is there any way to do this currently with vba and access?

thanks,
gnat.