Is there a limit to number of functions/subs in a Form Module

[JrMontgom]

Is there a limit to the number of fucntions/suroutines in a Form's module. I got an overflowerror when compiling and I moved a fucntion from the Forms mdoule to another module and the error did not re-appear.

[pbaldy]

Yes, though I can't remember offhand what it is. I think 65k lines. There's also a character limit per line.

[JrMontgom]

Yes, though I can't remember offhand what it is. I think 65k lines. There's also a character limit per line.

But is there a physical limit to the number of Fucntions/Subroutines/Module? My problem was solved by removing one function and placing it in another module.

[amrut]

Just for curiosity, how many fucntions/suroutines do you have in the Form's module?

[rpeare]

I think that question has already been answered

the functions aren't limited, the space to write them is.

[pbaldy]

Likely moving a function brought you below the overall limit. I've seen this, but not on an MS site:

Max 1,024 characters per line.
Max 6,601 lines per procedure.
Max 65,545 lines per module.
Max 1,000 modules per database.