ilove dogs said:
How do you increase the number of controls on an access form? I have
plenty of disk space.
A form has a maximum number of controls (about 754) that can be added
over the whole lifetime of the form. If you hit this limit -- but not,
I hope, because you actually have 754 controls on your form at the
moment -- you can ...
(a) Create a new form, then copy/paste all controls and code from the
old form to the new one, or
(b) *Maybe* use DoCmd.TransferDatabase or DoCmd.CopyObject to copy the
form to a new form in the same database. I don't know whether this
resets the count or not, but if so it's simpler than (a). Or,
(c) *Maybe* use the undocumented Application.SaveAsText and
Application.LoadFromText methods to save the form as a text file, then
load it back in as a new form. I don't know whether this would work or
not. Or,
(d) Search Google Groups for other postings on this subject. I seem to
remember seeing another method for resetting the count, but I can't
remember what it was.
