Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in a report. Is there a way to when the word is to long for
the field to go to the next row, but shrink the font down so it still fits in
that field just now on two lines?
 
You can use the OnPrint event of the section where the text box is located
in, and check the length of the string, if it's grater the a certain number
change the font size.
Something like

If Len(Me.FieldName) > 10 Then
Me.FieldName.FontSize = 8
Else
Me.FieldName.FontSize = 10
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shrink 3
stacked fields 'can grow' but overlap in report 2
Report Shrink 1
Report Fields that Auto Shrink/Grow 7
Shrink the Text 1
Only change font fomat in select words within a memo field 9
How to subtract a number from a Mergefield? 0
Report footer on same page with 2 columns page setup 1

Back
Top