David,
Actually, I do calculations using FONTMETRIC() quite similar to what you show here for my forms and put the value in the controls .Width property. My problem is doing the same thing in the Report Designer. Any ideas?
>Colin,
>
>>So it's basically development by trial and error
>
>Mostly that's true. No one has mentioned the fontmetric() functions they can be used to help figure out how wide to make things. But even that's not perfect, it really is a function of the data. Especially when using proportional width fonts. The kerning greatly affects the size of the fields. It also depends if the field is mixed case or all uppercase. A happy medium that seems to work well is to use FieldWidth * 1.5 * ( AverageCharWidth + MaxCharWidth ) / 2 for a mixed case field. If you are using an uppercase field you should FieldWidth * MaxCharWidth.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.