G
Guest
I have an application with a couple of dozen different reports. They are
reproductions of standardized state forms so I can't change the layout of the
report. All my fields are set to a 10pt font. The problem is that sometimes
the data won't fit. Can Shrink/Can Grow won't help because I can't expand the
field sizes. The only way to make things fit is to lower the font size. I
want to use the largest font size possible that will accommidate the data in
each field. (If 10 is too big, try 9. If 9 still too big go to 8 etc.)
I've seen this code for the On Format property
If Len([NameField])> 20 then
[NameField].FontSize = 8
Else
[NameField].FontSize = 10
End If
This will work but I've got a bunch of reports with who knows how many
fields. Is there some way to get the result I want without using the On
Format code for every field on every report? I hoping for a miracle shortcut.
TIA,
Lynne
reproductions of standardized state forms so I can't change the layout of the
report. All my fields are set to a 10pt font. The problem is that sometimes
the data won't fit. Can Shrink/Can Grow won't help because I can't expand the
field sizes. The only way to make things fit is to lower the font size. I
want to use the largest font size possible that will accommidate the data in
each field. (If 10 is too big, try 9. If 9 still too big go to 8 etc.)
I've seen this code for the On Format property
If Len([NameField])> 20 then
[NameField].FontSize = 8
Else
[NameField].FontSize = 10
End If
This will work but I've got a bunch of reports with who knows how many
fields. Is there some way to get the result I want without using the On
Format code for every field on every report? I hoping for a miracle shortcut.
TIA,
Lynne