Changing the format in a text box

[jasony]

I have an issue that is driving me nuts. I have a report that is printing out what is called a "talker". It prints out in 2 columns and and 2 rows so that is 4 per page. The issue I am having is there is a text box that has information in it. That info is different per "talker" and depending on the length of characters in that text box, I want the font to grow or shrink so that it covers most of that text box. I have tried a few different solutions but nothing is working 100%. If any one has any suggestions, I would be very grateful.

Thanks,

Jason

 

[vbaInet]

You want to Font Size to become larger or smaller depending on the number of characters in the textbox or you want to textbox to grow or shrink?

 

[jasony]

I would like the FontSize to become smaller or larger. The textbox must stay the same.

 

[vbaInet]

Have a look at this:

http://www.lebans.com/autosizefont.htm

 

[jasony]

Thank you but this looks pretty complicated and possible above my level of programming. I dont know where to start to incorporate that. Any other simpilar solutions?

 

[vbaInet]

Unfortunately what you're asking for is not a built-in function in Access. This is advanced stuff. You may need to rethink your approach.