Can grow - how to make all fields grow when only one grows due to more data?

[jmuirman1]

I have 5 multiple fields or text boxes in a row in a report.

I have all of the fields set to “can grow”. However, when field 2 has a lot of data the field grows accordingly, but the rest of the fields do not. Consequently 4 fields are the normal size but the 1 field is larger. I also have borders on each of the fields.

Thanks,



John

[Minty]

Simple answer : Put a single text box around the whole set of controls in that group.

Complicated answer : You can get the height of the section or the known largest control, and in the on format event with VBA you can extend the other controls height to match it.

[Micron]

Or remove the control borders and it should look 'perfect'. Control borders in reports just make for overly busy/cluttered display IMO.

[jmuirman1]

Thanks. What would the VBA code be?

John

[jmuirman1]

Thanks. I would, but the report has to match exactly one from another company which has borders.

[Minty]

Thanks. What would the VBA code be?

John

I did say this isn't simple.
You need to identify the tallest control - if you only really have one control that will grow then in the OnPrint event you need to get it's height, and set the other controls to match it.
So let's assume field 2 is in a control call txtLargeData.

This is air code (untested) and you will need to change the made up control names to match your reports control names.
Something like

Dim lgLargeHeight as Long

lgLargeHeight = Me.txtLargeData.Height

Me.txtOtherField1.Height = lgLargeHeight 
Me.txtOtherField3.Height = lgLargeHeight 
Me.txtOtherField4.Height = lgLargeHeight 
Me.txtOtherField5.Height = lgLargeHeight

If it doesn't work, post back exactly what you wrote as code and either highlight the error line or show us pictures of the formatting going wrong.

[Micron]

And that one is dynamic and is an Access report? Then copy the design?
Or perhaps you meant it was in some other form, such as Word, wherein all table cells increase in height when just even one does.

I don't think the single control idea will work for you - you'd get outer vertical border that will increase in height, but if you have borders in between (on each other field) their vertical borders won't grow. I'm a little rusty on this subject, but I thought the cangrow property only takes effect when printing. That is true of forms, but maybe not for reports. Anyway, your question has been asked many times by many others and solutions were accepted. Perhaps this one will work for you.
https://stackoverflow.com/questions/...oring-controls