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

Possible to have section of report not print based on content in table 2
Separate grow/shrink columns on single report page 1
possible to have sections of memo field bold in a report 2
Any way to combine printing of 2 reports into a single print job? 1
Make a text box fit the value inside 4
Group Header section height will not shrink 1
Any way to make 2 separate reports print as the front and back of a single page? 4
Adjust automatically fontsize on control of report 1

Top