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

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)
 
M

Marshall Barton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grow/Shrink Text gradually from slide to slide 0
Anyway to control increment size of grow/shrink on MS Access Report? 0
Possible to have section of report not print based on content in table 2
Problem with line spacing and Text Field "Growing" 0
Separate grow/shrink columns on single report page 1
Problem with reports flowing onto second blank pages 0
Make a text box fit the value inside 4
Problem with reports flowing onto second blank pages 0

Top