If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Colunm headings in Subforms
I have a Subform on a form and the title headings in the Subform are too
long. This means that to be able to see all of the data the user has to use the horizontal scroll bar. This is not very practical as it means either taking your hand away from the keyboard and using the mouse to scroll or when moving into a box which is not visible all of the boxes move along. The outcome, of course, is that not all of the data is visible at any one time. I need all of the data in the Subform to be visible all of the time. Is there any way I can make the titles in the column headings look like the ones below? Order instead of Order Value Value |
#2
|
|||
|
|||
On Sun, 3 Apr 2005 10:01:02 -0700, pompeyjim
wrote: I have a Subform on a form and the title headings in the Subform are too long. This means that to be able to see all of the data the user has to use the horizontal scroll bar. This is not very practical as it means either taking your hand away from the keyboard and using the mouse to scroll or when moving into a box which is not visible all of the boxes move along. The outcome, of course, is that not all of the data is visible at any one time. I need all of the data in the Subform to be visible all of the time. Is there any way I can make the titles in the column headings look like the ones below? Order instead of Order Value Value One easy way is to not use Datasheet view for the subform - use a Continuous Form instead. Use the View menu option in design mode to view the Form Header; put whatever titles you like in label controls on the header, and textboxes squeezed up to the top of the detail section and side by side. Bring the bottom of the detail section up to the bottom of the textboxes and you'll get the look of a Datasheet but the control provided by a continuous form (i.e. users won't be able to resize columns on you). John W. Vinson[MVP] |
#3
|
|||
|
|||
"John Vinson" wrote: On Sun, 3 Apr 2005 10:01:02 -0700, pompeyjim wrote: I have a Subform on a form and the title headings in the Subform are too long. This means that to be able to see all of the data the user has to use the horizontal scroll bar. This is not very practical as it means either taking your hand away from the keyboard and using the mouse to scroll or when moving into a box which is not visible all of the boxes move along. The outcome, of course, is that not all of the data is visible at any one time. I need all of the data in the Subform to be visible all of the time. Is there any way I can make the titles in the column headings look like the ones below? Order instead of Order Value Value One easy way is to not use Datasheet view for the subform - use a Continuous Form instead. Use the View menu option in design mode to view the Form Header; put whatever titles you like in label controls on the header, and textboxes squeezed up to the top of the detail section and side by side. Bring the bottom of the detail section up to the bottom of the textboxes and you'll get the look of a Datasheet but the control provided by a continuous form (i.e. users won't be able to resize columns on you). John W. Vinson[MVP] Thanks very much John. That has done the trick. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subforms with several subforms | Peter Höltschi | General Discussion | 1 | March 22nd, 2005 11:20 PM |
Disappearing Subforms | Bryan | Using Forms | 0 | March 3rd, 2005 02:17 PM |
Disappearing Subforms | Bryan | Using Forms | 0 | February 22nd, 2005 02:15 PM |
Subforms crash using ODBC | Dick Kusleika | Using Forms | 0 | January 11th, 2005 08:35 PM |
Update two subforms based on one table together? | Flora | Using Forms | 0 | August 6th, 2004 12:59 AM |