I have to verify double-entered records and have about a hundred fields to check. It was all working fine when I just had "If val1<>val2 or isnull(val1) and not(isnull(val2)) etc. but then I imported it from Access 2000 into 2003 and 2003 said the procedure was too big. I'd never heard of this before. So I had to cut down on the code by making the comparison a function call.
I knew Access had a maximum size for code per procedure but I've never heard of anybody hitting it before. On the other hand Access is notorious for becoming less functional with each version. Microsoft seems determined to remove something from Access for each feature they add.
Jay