asked on

Auto Size font in fixed text box

I am working in Access on a report which will create employee badges. All the text boxes and labels are a fixed size.

When selecting a font for the employee name, I want to select the largest font available for the text box, however I have no way of knowing how long or short the length of any given name will be.

Does access have a format to resize text in a text box so that no matter how long the string of text is, the font will resize to fit the name in current text box?

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

IrogSinta

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MCaliebe

ASKER

I've done general code, tables, query, ect but this seems way over my head. IrogSinta, do you have an example of the rule you used? I'm not looking for anything fancy...simple font size change is about it.

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

<When selecting a font for the employee name, I want to select the largest font available for the text box, >
Let's be clear here...
You want to select a different Font *Style* (Arial, Times New Roman, Comic Sans,...etc)
..or change the font *Size* (10 pt, 12 pt, 20 pt)
Or both...?, ...or neither, more something else entirely...?

Please post a clear graphical example of two extremes and the *EXACT* output you want.

MCaliebe

ASKER

Thanks for everyones input. I can see the compexity involved here and I will be taking the simple approach ...select a font, size and use it until it doesn't work.

Jeffrey Coachman

Yes, also remember that the "Size" of the font effects the Height and Width
so again, no easy answers here.