Access - Mainform with Subform - Getting Subform Page Headers to show or Data Sheet titles to wrap

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-05-11
Hi EEers

I have a form with 3 subforms.  I have tried setting up the subforms two ways.  I have tried the subforms as Datasheet View and as Continuous Forms View.

In the Datasheet view the Column headings show as one line tall titles (can't wrap them to 2 lines).  In Continuous Forms View I can't get the Page Headers of the Subform to show (Tried this so I could wrap my column titles to 2 lines tall).

Am I missing something or can this not be done?
Question by:wlwebb
  • 4
  • 3
LVL 41

Expert Comment

ID: 35745117
May be you can draw example of expected result?

Author Comment

ID: 35745161
What I want is the Subforms column titles to allow 2 lines:


I have a column titled "Job Cost Item Group"  It take up a lot of real estate side to side.  What I would like is for the column heading to be
"Job Cost"
"Item Group:

If I use a Continuous Form setting then these "Page Headers" of the subform don't show up at all.

If I use Datasheet View Form setting then all I get as the heading for the column is whatever I have named the column all on one line.  Is there a way to get those column headings on 2 lines?
LVL 41

Expert Comment

ID: 35745201
Have you tried to change Layout to Tabular?
You can add new (or divide) line in header with <Control><Enter>
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.


Author Comment

ID: 35745240
I'll try it

Author Comment

ID: 35746151
How do you change it to "Tabular".  In my Default Views I see Continuous Forms, Datasheet, Single Form, Pivot Table, Split Chart.

LVL 41

Accepted Solution

als315 earned 2000 total points
ID: 35746264
It is not a form view - it is layout of Continuous form. Select fields in form design, with right mouse button select Layout - Tabular (I hope you have Access 2007 and later). If not - you can do the same manually: move field header to form's header and change it size as you want.
You can also add any text in the form header and place your fields with deleted titles under this text.

Author Closing Comment

ID: 35746658
Ok, Got it.  Yes I have Access 2007

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question