A CanGrow question

[Funger]

Hi All.

I've built a reportcard report. On this report are five text controls: the subject area, and the grades for the four quarters for that subject area.

Because of the length of some of the subject areas, I want to make the subject area control CanGrow.

However, when the control grows in this way, I can't figure out how to make the quarter grade controls grow to the same size. Can someone please help me?

If the only way to accomplish this is by using the line function, then can someone please explain to me how to use this function? I've tried to implement it in the past, with minimal results.

Thanks!

 

[DALeffler]

From Acc97 Help "CanGrow, CanShrink Properties"

If you set a control's CanGrow property to Yes, Microsoft Access automatically sets the CanGrow property of the section containing the control to Yes. (However, if you set a control's CanShrink property to Yes, Microsoft Access doesn't set the section's CanShrink property to Yes.)

Sections grow and shrink vertically across their entire width. For example, suppose a form has two text boxes side by side in a section, and each control has its CanShrink property set to Yes. If one text box contains one line of data and the other text box contains two lines of data, both text boxes will be two lines long because the section is sized across its entire width. To grow and shrink the data independently, you can place two subform or subreport controls side by side, and set their CanGrow and CanShrink properties to Yes.

I would try vertically enlarging all the controls in the Detail Section of the report to be large enough to contain two lines of text.

Set the Can Grow/Can Shrink properties for all controls to yes. Then set the Detail Section of the report "Can Shrink" property to yes.

Lemme know if that works...

 

[WayneRyan]

Funger,

Access controls "can grow"/"can shrink" independent
of one another. Therefore, if there are different
amounts of lines in the textboxes, that row appears
"jagged".

The only solution that I have seen is GrowBox which
works pretty well:

http://www.access-programmers.co.uk/forums/showthread.php?t=40186&highlight=growbox

Give it a try,
Wayne