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
|
|||
|
|||
Report field does not grow
I am creating a report which groups steel and plastic components for an
item and prints the those components in two lists. I may have have up to 25 items associated with the steel or plastic and I am building a comma separated list in the report from query data. When the report prints, I get only a single row of data for each component whether or not it fills more than one row. When I expand the field to multiple lines and do not allow it to shrink, the data shows for larger list, but I get blank space on smaller lists. If I allow it to shrink, I get only 1 row even when there are multiple rows. I have the field set to can grow and the section, which is in a footer is also set to can grow. Using a 'dash instead of a comma does not help. |
#2
|
|||
|
|||
Report field does not grow
This strikes me as a "Reports" question, not a "Forms" question...
If your report includes a control to the right of this one, and aligned, the CanGrow/CanShrink properties get confused by the properties of the control to the right. Regards Jeff Boyce Microsoft Office/Access MVP "Bob" wrote in message oups.com... I am creating a report which groups steel and plastic components for an item and prints the those components in two lists. I may have have up to 25 items associated with the steel or plastic and I am building a comma separated list in the report from query data. When the report prints, I get only a single row of data for each component whether or not it fills more than one row. When I expand the field to multiple lines and do not allow it to shrink, the data shows for larger list, but I get blank space on smaller lists. If I allow it to shrink, I get only 1 row even when there are multiple rows. I have the field set to can grow and the section, which is in a footer is also set to can grow. Using a 'dash instead of a comma does not help. |
Thread Tools | |
Display Modes | |
|
|