Report label text to fit

[thep]

i have a report created which has a textbox that pulls value from the table. when i pull preview the report the fiels text is not displying all the characters.
ex. in my table its 1234567890 but on the label it would show 123456.
i tried the Can Grow & Can Shrink but when i do this it changes the format and making my report to display on multiple pages.
is there something i can do so the entire text displays?
i am using access 2007.

 

[dhookom]

What do you want to do? Apparently you don't want the control to grow. Do you want to shrink the font?

Duane
Hook'D on Access
MS Access MVP

 

[thep]

if shrinking is an option then i would like to know how to do this? not just for everything only if it cant fit in the textbox then shrink.

 

[dhookom]

The only solution for shrinking the font is Stephen Leban's code.

Duane
Hook'D on Access
MS Access MVP

 

[thep]

Thank you
i will give it try.