Colunm headings in Subforms

[pompeyjim]

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

 

[John Vinson]

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]

 

[pompeyjim]

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.