Can grow

[chavez_sea]

Good morning
How can I make all fields in a report's Detail section grow in unison


I do not know codes . Is there an easy way.
Thanks

Cristina

[ranman256]

no code needed,
in report design mode,
select all fields
set property CAN GROW = TRUE

[chavez_sea]

Thanks. However, to explain further it is only one field that because of the amount of the data the field has to expand. But in the report, it looks bad as the lines are now out of whack, with ones that don't need to expand remaining, and one much wider. I would like to retain my borders as solid, as the report is in the form of a table. ANy suggestions.
Thanks

[CJ_London]

in the detail on format event put some code along the lines of

mycontrol.height=mygrowcontrol.height

alternatively, investigate using a line control below your controls for horizontal lines and the vba line method for vertical lines - then hide your borders

[Bulzie]

Another way is to put all the non growing fields in one row, then below that put the one field that can grow and just expand the width maybe the length of the top fields so it looks uniform.

[CarlettoFed]

Maybe if you attach the project you have made, it can give you better help.