Access 2000 - Expanding text to fit a field

[lleddil]

On a report that generates labels, I would like to adjust the text size/width automatically to fit the appropriate field length, such as one can do in MS Word with the 'fit text' function.

Any help on appropriate code would be appreciated.

 

[dcompto]

See if any of these will help...

http://support.microsoft.com/default.aspx?scid=kb;en-us;210321&Product=acc2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;209653&Product=acc2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;210589&Product=acc2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;207681&Product=acc2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;197595&Product=acc2000