Newb question here. I have a solution that uses multiple layouts that are printed - That single page print out is the end result, and it is all the user requires. Works OK.

One problem I have is that sometimes the data in a field is too long, cutting off part of the data for that line (each line is essentially its own field). I could reduce the font size on all layouts, but that is not desired when the data is shorter.

I would like to be able to allow the user to reduce the font size - or change the font entirely - for that one field if necessary. I am not opposed to adding scripts and buttons to accomplish this, but am clueless where to start.

Any ideas?

Thanks!

Birg

Got is sorted out - John Mark Osborne from databasepros dot com offered this and it was spot on:

---------------------------------------

Your best bet is a calculation using the Text Formatting functions.

Specifically, you want the TextSize function. Here's how you might use it.

Create a global number field and add a value list with the font sizes you

desire (10, 12, 14, etc). Then, create the following formula:

TextSize(MyTable::MyField; MyTable::MyGlobal)

MyField is the field you want to reduce in size. MyGlobal is the global created

above. Use the calculation on your print layout instead of the actual field.

Then, allow the users to popup the menu on the global field to change the

size of the font before they print.

--------------------------------------

- Birg