>>>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
>
>I see your point. Thing is, there's actually 35 fields in contention. The users want to see all of them on 1 screen. My mgr is advocating this as well. There is room as most textboxes are not that big. but as per my last message to Renoir, after the "create multiple controls here" operation, it leaves half of the texboxes beneath the forms border, never to be accesses again. :(
>I know I'm beating this issue to death............

OK then use scrollbars with form.
Or alternatively use a grid. You could show the grid in 'change' mode where fieldnames are listed at leftin one column and entry is in second column.

If still not acceptaple then you force them to buy a monitor that could show a 1280*1024 form :)
Cetin