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.

 

[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:

 

[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.

 

[DHookom]

Sattia, don’t worry about any code solution unless the post#2 solution doesn’t meet your requirements. If it doesn’t meet your needs, you should add some additional specifications.

 

[theDBguy]

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.

Hi. Welcome to AWF!

I have some instructions here. See if they can help you and let us know if you have further questions.

Report Gridlines

I don't normally create reports in my databases because I prefer to export the data into Excel or other format, so that the user can further...

thedbguy.blogspot.com