| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form to large
I am using Excel 2003. When I open my data form to review records in my
worksheet the form is wider than my screen. Can I resize the form? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Form to large
Are you talking about the built-in Form you access from DataForm?
I have never seen such a phenomenom with that Form. Or one you have created? In which case, you control that when creating it. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 12:01:00 -0800, dfrost57 wrote: I am using Excel 2003. When I open my data form to review records in my worksheet the form is wider than my screen. Can I resize the form? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Form to large
Yes I am refering to the built in Data Form. I have 32 columns which forces
the data form to create two columns. I have done some tests and it appears to be driven by the width of the columns in my database. "Gord Dibben" wrote: Are you talking about the built-in Form you access from DataForm? I have never seen such a phenomenom with that Form. Or one you have created? In which case, you control that when creating it. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 12:01:00 -0800, dfrost57 wrote: I am using Excel 2003. When I open my data form to review records in my worksheet the form is wider than my screen. Can I resize the form? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Form to large
You are correct in your assumption.
32 fields is maximum allowed in a data from. The width of the form is governed by the width of the columns. I learn something new every day. My only suggestion is to truncate some of the field widths. Gord On Wed, 10 Jan 2007 03:58:00 -0800, dfrost57 wrote: Yes I am refering to the built in Data Form. I have 32 columns which forces the data form to create two columns. I have done some tests and it appears to be driven by the width of the columns in my database. "Gord Dibben" wrote: Are you talking about the built-in Form you access from DataForm? I have never seen such a phenomenom with that Form. Or one you have created? In which case, you control that when creating it. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 12:01:00 -0800, dfrost57 wrote: I am using Excel 2003. When I open my data form to review records in my worksheet the form is wider than my screen. Can I resize the form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
| Using data form in large mailing list spreadsheet | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Saving data to a form datasheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
