Continous form with infinite width and Height 1

[barnard89]

Hi

I am using MS Access 2000
I need to place innumerable number of controls on my Access form
(close to 1900 Controls)

My form has only dimensions of 22" (ht) X 22"(wd)
Hence I am not able to place all my controls on the forms
Is there way I can expand my Access 2000 Forms
and make them flexible so that I can accomodate all the controls in one form?

Please suggest

 

[PHV]

Anyway no more than 255 active controls in a form ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MichaelRed]

[qoute PHV] " ... no more than 255 active controls ... " [/quote]

Normally, yes. And I heartily endorse the overall attitude, expressed quite elequoently by G. Orwell ("Less is More"). But there are several workarounds / oddities. Most convenient is the use of SubForms.


While I would NOT suggest that [/b]banard89[/b] attempt the trick (even posing the issue seems to demonstrate that the learning curve has a few steep sections between his present position and the realization of 1900 anythings in a Ms. A. db) but clever and determined professionals have broken through this barrier often.



MichaelRed