AutoFit Text size to display in a form textbox

[QA_Compliance_Advisor]

has anyone come across any forums or solutions which allows me to have a autofit text in a textbox in a form textbox.

I would have thought there was some form of logical calculations/ formula/ pattern which text size, font and textbox size correlate to each other, has been devised. Allowing the calculation of textbox size, font and font size to automatically adjust font size to display all text within a textbox. Sane idea as MS Word allows to automatically adjust text size to the size of the textbox.

In my circumstance it is a text will be short maybe up-to 40 chars but it is displayed significantly large. can grow/shrink is not an option. There has been a few options i have seen on forums but i have not been able to open this applications due to I am running a 64bit office 2013.

any help would be great.

[ItsMe]

I would guess that any changes made to the control would have to be performed during Design Time and cannot be done in a pure Run Time environment. So the User would have to have a full version of Access installed on their machine.

It probably would not be too difficult to build a function that would analyze the length of a string and modify a control based on the result. Maybe pass the name of the form and name of the control to the function or pass the actual control to the function as a control.

Why are you having trouble opening the examples you are mentioning? You do not have any sample code?

[QA_Compliance_Advisor]

I cant remember where the sample database was from but i downloaded it but cannot open it due to it being created on a 32bit office .mdb (pre 2007) database - i am assuming that due to the old structure and/or the version is causing me an issue to open the database in Ms Access 2013 64 bit.

[ItsMe]

Access 2013 does not like mdb files but you should be able to convert it. Anyway, I would build a Public function within a Standard Module and pass the name of the form and the current control to it. Then, the function could adjust the font size. I would leave the control width alone and have it preset for the maximum width possible. You should be able to adjust the font size during Run Time but I do not believe the control width is available during RT.

[CJ_London]

take a look at this function created by Stephen Leban. http://www.lebans.com/autosizefont.htm

If you can't open it, let me know and I'll save it as a .accdb

[QA_Compliance_Advisor]

Ajax, this is the sample database I have downloaded but cannot open.

If your able to convert this database it would be greatly appreciated.

[CJ_London]

here you go - click through the different records to see changes in font size