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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

procedure is too large 2
"Fields Nested Too Deeply" Error in Simple Word Document 5
Compile Error: Procedure too large 1
Procedure Too Large 4
Procedure too large 1
Compile Error: Procedure too large 1
How To Programmatically Set A Procedure Name To A String Variable 2
Error Procedure too large 1

Top