Compile Error Procedure too Large

Q

quixote

Has anybody ever seen this error:"Compile Error: Procedure
too large"? If so anything to fix it. I have a few long
functions and some procedures. I have tried putting each
method in its own module but still get this error. I have
tried both Access 97 and 2000. Both tell me procedure is
too large. any thoughts?

Thanks
 
J

John Spencer (MVP)

Break your procedure into sub procedures.

I'm not sure of the maximum length of any one procedure, but I've never run into it.

Any procedure long enough to run into this message is suspect in my opinion.
 
Top