Does Access 2003 allow text shrink-to-fit in a CanGrow=No Text Box

[Guest]

I have an application that is printing labels (x number to a page).
I need to constrain varying length label data to a specific area without
truncation and a limited amount of text wrap.
Preferable, the text needs to shrink if it is too long to fit in a
constrained Text Box.

 

[Terry]

Hi,

Have a look at www.lebans.com he has some pretty nifty
stuff for fitting text into a control.

Alternatively something like :
if len([your text])> 25 then ' or whatever fits unaltered
[yourtextbox].fontsize = 10 ' or whatever size
end if

The syntax is off the top of my head so will probably need
some fixing. This code can go in the Section's "on Format"
event.

HTH

Terry