Report Field Heights

jarra_mackem

Registered User.
Local time
Today, 17:53
Joined
Feb 28, 2008
Messages
17
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
 
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)
 
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
 
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
 
Draw vertical lines the length(height?) of the detail section.

edit No that won't work
Sorry cannot help.

brian
 
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?
 
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
 
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
 
For some reason my computer wont let me open the mdb after ive downloaded it? Anyone else had this problem??
 
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
 

Users who are viewing this thread

Back
Top Bottom