Controls and Procedures

[DUF]

Hi,
I have seen this before some tome ago here but can not find it
What is the Max number of Controls you can have on a form am I right in thinking it around 200 controls?.

Also when codeing a procedure I know that procdeure can not be more then 63Kbs in lenght (I think) Is there a way to check the size of the procedure before Access Compiles it??

Thanks

Duff

 

[WildHare]

If there is a limit to the number of controls on a form, I haven't seen it in all my years of using Access (v1.0).

I also haven't run into any procedural size limit, so I won't be much help there either.

I don't think there's anyway of checking the 'size' of a proc before you try to compile it, short of Copy and Pasting it to a plain ASCII text file editor (e.g., Notepad) and checking the byte size...

One of the "largest" forms I had to do was a year or so ago, when I converted a poorly designed system. This was an employment assistance program, where the questionnaire was about 10 pages long. I normalized the design a little better, and managed with a main form and 7 layered subforms that were made visible via command buttons. There's a sample of it on my site (link at the bottom of this post). I think if you use subforms, you can get around any 'logical' limit to the number of fields.

Hope this helps a bit.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm