Resizing of field on a report.

[Terry DeJournett]

I have a report (label) that has one particular field on it that depending
on the item could have as few as 3 lines of text or as many as 15 lines of
text (Text comes from a memo field in the database). Does anyone know if it
is possible to resize the font automatically for this field on the report?
In other words for the record that has only 3 lines of text that the font be
larger than the record that prints the 15 lines of text which is currently
set to a font size of 6.

Thanks in advance for everyones help this afternoon.

Terry

 

[Guest]

In the onformat event of the detail section of the report add something like
the following:

If Len(Me.field) < 50 Then
Me.field.FontSize = 8
Else
Me.field.FontSize = 6
End If

Len command returns the number of characters not lines