Access 2007 fields don't grow together

[NapoliNick]

I have a report in Access 2007 that uses fields in a continuous form, one row
and 6 fields accross. Because the length of data is the fields is
inconsistant, I turned on the "Can Grow" options for all fields in form. The
problem is, if one field grows, the others do not and the "Table Effect" is
lost because the height of the fields is now different. Is there a way to
make the borders of all of fields grow if any one of them does?

 

[Larry Linson]

I have a report in Access 2007 that uses fields in a
continuous form, one row and 6 fields accross.

Hunh? Continuous Forms View is one option of Forms; a similar display
format is just the way a normal Report Detail Section works.

Because the length of data is the fields is
inconsistant, I turned on the "Can Grow"
options for all fields in form. The problem is,
if one field grows, the others do not and the
"Table Effect" is lost because the height of
the fields is now different. Is there a way to
make the borders of all of fields grow if any
one of them does?

I believe the phenomenon you describe is not new with Access 2007. CanGrow
works on a given Control and the Section in which it occurs; it does not
"spill over" to adjacent controls. If you search the web and Knowledge Base,
and Google Groups for the archives of Access newsgroups, you will find a
number of discussions of how to create a consistent grid, but I don't know
if any of them are "totally satisfactory".

One possible way to do what you want is to export the pertinent data to an
Excel spreadsheet, and print from there. In Excel, if you expand the height
of one cell, all the other cells on that row are expanded to match.

Larry Linson
Microsoft Access MVP

 

[NapoliNick]

Larry,
Thank you for the response. The reference to "Continuous Form" was
incorrect but an attempt to describe the diference between a single record
entry being displayed or a group of records in series being displayed. I
don't want to date myself but I started on Dbase 3 and at some point (either
dbase or access2) allowed you to group and ungroup fields to make them
respond as one. I will try to export to excel but it be over my head. The
form as it is now is a single financial document with all funding document
numbers, points of contact at several approval levals and the section in
question is actually a subform that lists any deliverables or preset labor
costs. I'm looking it up right now and thanks again...

NapoliNick55