Report Field Heights

[jarra_mackem]

I was wondering if anyone could help me with this

Im printing out a report and i want to alter the heights of the text boxes on the report.

Basically i have 12 text boxes side by side holding data. I want all of them to match the height of the tallest (which is a choice of 4 the others are Y/N fields)

I want them to appear as one row by using their borders as a cell divider if that makes sense?

Im unsure as to the method behind this?

Any help greatly appreciated

Regards

Paul

 

[Brianwarnock]

The facilities to do this are available in design view.

Brian

 

[jarra_mackem]

The text boxes grow depending on the data in them. However i want them all to grow equally.

so that I have one row where all the text boxes are equal height but appear as if they were one row (like an excel row)

 

[Brianwarnock]

So you want to dynamically grow all textboxes to the size of the largest.
I don't know how or if that can be done, I kind of doubt it.
Why not remove the textbox borders and place a line along the bottom of the text boxes, this will delineate the rows at the largest text box.

Brian

 

[jarra_mackem]

Yeah i want them to dynamically grow. Like you say im not sure if this is possible.

I have had the line at the bottom and the top but would like to split each of them into columns as well

 

[Brianwarnock]

Draw vertical lines the length(height?) of the detail section.

edit No that won't work
Sorry cannot help.

brian

 

[jarra_mackem]

Unfortunatley ive never use the draw line method before and cant really find any helpful examples.

Do you have any idea where i could find some?

 

[Brianwarnock]

I've taken a look and discovered that the height of the textboxes during the detail section On Format event is the default height, not the height that the box will be, I guess the growth is done later, thus VBA cannot be used to change all the box sizes to the largest after that growth, if you get my drift.

I don't think you can do what you want.

Brian

 

[jarra_mackem]

I think i have a fix, but to be honest its bit messy

Basically creating blank boxes based on the number of charcters allowed in each box. Filling it with one character and enough carriage returns to pad it out to the correct height

 

[RuralGuy]

Maybe you will find this link helpful.

 

[jarra_mackem]

For some reason my computer wont let me open the mdb after ive downloaded it? Anyone else had this problem??

 

[Brianwarnock]

No I had no problem unzipping and opening the 2k version. I haven't looked ay the method yet and probably wont have time today.

brian