Table Headings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to change size of table headings without making them wider
(i.e double rows, wrap text). I have a lot of colums with check boxes, etc
where the data is small but the column has to be very large in order to show
entire heading
 
There's no way to change the size of the headings, but then you shouldn't be
working directly with the tables anyhow: that's what forms are for.
 
Greg,

Make a form from your table. Manipulate the form so it shows a set of
desired fields, and set the form for Continuous Forms mode. Then, manually
select DATASHEET VIEW for the form, and manipulate those columns to suit.

Now, use this first form as a SUBREPORT in yet another form.

Drag your SUBREPORT FORM to a new blank form to make a subreport of your
table.

Put column headings onto the new form as text boxes which you can control,
positioned over columns in the SUBREPORT when the SUBREPORT (not this second
form) is set to DATASHEET VIEW.

Use the subreport in DATASHEET mode. Hide and move around columns to suit
your purposes. If you are in ACCESS 2002 up, you can do a lot of
manipulating of the table's datasheet appearance in Design Mode right in the
form.

Of course, if you have a LOT of columns to show, it can get tricky. You
could create a Tab Control on that blank form when you first created the
form, THEN drag the SUBREPORT FORM onto a SELECTED tab page (important to
select a tab before pasting onto it). By then COPYing the subreport so
created to multiple pages (tabs) on that tab control, you could set up a
different view of the same subreport, showing various columns, on each tab,
making it easy to switch to more columns. Each tab's view of the subreport
will show independent views of your original table. One tab could be set to
DATASHEET VIEW while another could still be in CONTINUOUS FORMS mode.

Pretty versatile way to show a lot of fields in a single table.

Hope this helps.
 
Back
Top