Hello All

I have a VFP report which I need to scale the font to fill a specific area. The number of characters can vary widely but needs to be printed as large as possible. I have several approaches I have been considering but none of them are very clean. I am hoping someone has come up with a clever solution to this problem. The approaches I have considered...

1) The current implemented method has two fields on the report on top of each other, using the when clause I determine which one is displayed depending on the number of characters. Crude, but supplies only two sizes, and dosn't take into account the proportionality of the fonts.

2) I could use automation or some other technique to make a graphic that represents the text, then have it scale to size. Output wise this would be great if someone can give me a snippet to create the graphic.

3) I could determine what would fit using textwidth() and a multiplier which I could use trial&error to come up with. I could then either hack the FRX or have many different sized fields on the report and send a variable that can be used in the print when of the field to determine which one will print.

Looking for a clever solution, all comments welcomed

Thanks in advance

Bob