Now that you guys got me this far, :) How can I capture the Dblclick in the headers?
>
>To make your function more universal replace the 7 with fontmetric() getting the average character width if your field is mixed case or getting maxwidth if the field is uppercase.
>
>>Hi Alan,
>>
>>>What is the formula to calculate the proper width of each column?
>>
>>Here's what I use:
>>
>>
size = iif(FieldSize < 3, 20, FieldSize * 7 + 4)
>>
>>I use AFields, so the third element is what I use for FieldSize, but you may want:
>>
>>
size = iif(fsize(field(lnI)) < 3, 20, fsize(field(lnI)) * 7 + 4)
>>
>>This Help?
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108