Changing height of text box control as row height changes

[Brett]

I alternate the color of rows in my reports and alternate the color of
columns (i.e., text boxes). This works well to distinguish one row from
another, as well as one column from another, especially when the text
box background color is slightly darker than the row color (when the
row has color). However, when the row height changes (e.g. a text box
that labels the row grows) the text box height (column) does not
change. This leaves colored columns with the background row color
showing underneath each column, creating a gap in the columns. How do I
reference the current row height on the onformat event (or another
event) so I can change the text box height to fill this gap?

 

[Albert D.Kallal]

Are you talking about a form?

Unfortunately, this is one thing that access can't do.

A report can do this..and you just have to set the can-grow property of the
text box to yes...