Equal height in columns

[sattia]

In a continuous report in Access, I have two columns, one of which contains notes and the other contains numbers. The incrementable property of the notes column has been changed to Yes.
The height of the notes column has become greater than the number column. How do I make the height of the number column equal to the height of the notes column in all records?

 

[arnelgp]

on design view of your report, highlight the column headings and the detail textboxes (1).
the on the ribbon, choose Arrange->Tabular (2).

 

[sattia]

I want the column height to be equal to the last column

 

[Gasman]

Repeating what you just said is not going to help anyone?

 

[Gasman]

Welcome to my IL.

 

[sattia]

i cant attach file

 

[sattia]

I have several columns and I want their height to be equal to the notes column.

 

[CJ_London]

You were shown how in post #2. Nothing more we can add without you telling us why that is not what you want.

Perhaps you mean dynamically grow? If so then can’t be done on a form, only report

 

[sattia]

You were shown how in post #2. Nothing more we can add without you telling us why that is not what you want.

Perhaps you mean dynamically grow? If so then can’t be done on a form, only report

yes in report
I want all rows to be equal in height according to the height of the notes column.

 

[GPGeorge]

yes in report
I want all rows to be equal in height according to the height of the notes column.

Please tell us what actually happened when you tried the suggestion offered in Post #2. What was the result of your attempt to implement it? Was it not what you wanted?

 

[CJ_London]

Maybe the OP is talking about the can grow/shrink property?

 

[DHookom]

If you have the border displaying and want them all to be the same “grown” height, you can use the height of the notes in the On Print event of the section to draw rectangles/boxes around the other controls.

 

[Pat Hartman]

I'm pretty sure that @arnelgp 's solution solves the problem. The old way was to calculate the height in the format event for the text control and then use that to change the height of the other controls. No code solutions are always better when one is available.

 

[DHookom]

Thanks Pat. I guess I'm too old school. Here is a screen shot of the Print Preview which should clarify the use of @arnelgp 's suggestion:

 

[Pat Hartman]

I don't ever use this "grouping" except for reports. Many people also use it on forms but I think it takes up too much room.

 

[sattia]

Thanks Pat. I guess I'm too old school. Here is a screen shot of the Print Preview which should clarify the use of @arnelgp 's suggestion:
View attachment 116703

yes
can attach example
thanks

 

[DHookom]

yes
can attach example
thanks

Are you asking for someone to attach a sample of the equal heights? The description with a screenshot and steps is quite clear.

 

[sattia]

Are you asking for someone to attach a sample of the equal heights? The description with a screenshot and steps is quite clear.

thanks DHookom
Yes if you attach a sample of equal heights? I would be very grateful

​

 

[CJ_London]

What don’t you understand about post #2?

 

[sattia]

What don’t you understand about post #2?

post #2 ok
but not understand
If you have the border displaying and want them all to be the same “grown” height, you can use the height of the notes in the On Print event of the section to draw rectangles/boxes around the other controls.