Keeping row heights consistent in a grid

[wiggychoo]

Hello

I have a report that displays information in a grid (see attached).

I want to make the coloured boxes in each row match the height of the text boxes on the left (which have 'Can Grow, Can Shrink' properties) so that it displays more tidily as a grid.

The coloured boxes have little or no text in them but are simply there to flag up the colours.

Does anyone know whether this can be done?

Thanks!

 

[DCrake]

Untested but you could try setting the text boxes hight to that of the description height

On the on Print/format event, not sure

Me.FieldName.Height = Me.Descritpion.Height

David

 

[wiggychoo]

David

Thanks for your help - have been away for a few days but back onto this now. I'm was not sure what you meant by the 'description height' so I tried the following code in the Detail section 'On Format' event of my report:

Dim SchemesTXTHeight As Single

SchemesTXTHeight = Me.txt_ListEntry.Height

Me.txtFUNDING.Height = SchemesTXTHeight

It didn't work...any ideas??

Thanks again

Matt