Any way to control the size by which a text field on a report grows/shrinks?

  • Thread starter Thread starter ghadley_00
  • Start date Start date
G

ghadley_00

Hi,

I have an MS access report with multiple fields that grow and shrink.
The report has a backgroun with which I would like to the keep the text
formatted. Is there a way to control the size by which a text field can
grow/shrink?

Best wishes,

George Hadley
(e-mail address removed)
 
I have an MS access report with multiple fields that grow and shrink.
The report has a backgroun with which I would like to the keep the text
formatted. Is there a way to control the size by which a text field can
grow/shrink?
Click to expand...


Why not just keep the text box at a fixed size?

To answer your specific question, no. CanGrow/CanShrink
change size to the best fit of the value being displayed.

However, you can calculate the space required for the value
in the Format event and set the text box's Height property.
To calculate value's vertical space, use the fTextHeight
function at www.lebans.com
 
Back
Top