Resizing of field on a report.

  • Thread starter Thread starter Terry DeJournett
  • Start date Start date
T

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
 
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
 
Back
Top