>Cetin, I know your method comes in handy and will work for me, but the problem lies in visually moving the textboxes around so I can beautify the form and make it eye pleasing. I can't do that if I can't put my mouse below the form margin. Like I said previously....
>""">>Cetin, I have 50 fields, I only only visually access 18, whcih is how many can be displayed with my designer form maximized. Even if I scroll or resize! :(
>"""
>Can you duplicate this?
Tim,
In fact it's not that complex. Suppose instead of one form you did this in 3 temp forms each holding 17-18 fields and ran the code to set controlsources.
Then you create your master form, add a pageframe to it, 3-4 pages (how you like), then copy&paste from temp forms. You could even prearrange them in containers to make this easy or even create classes selecting 17-18 field groups (nicer I think). Believe me it would be finished in 5-10mins.
Cetin