Re: [AccessDevelopers] Changing font size in Report

[A.D.Tejpal]

Julian,       You can experiment with sample code given below, in format event of detail section. Title is the name of text box.       For a finer control, you could use criteria based on textwidth value (instead of Len function).   Best wishes, A.D.Tejpal   =================================== Private Sub Detail_Format(Cancel As Integer, _                                        FormatCount As Integer)     If Len(Title) > 30 Then         Title.FontSize = 9     Else         Title.FontSize = 12     End If End Sub ===================================   ----- Original Message ----- From: Julian Flint To: AccessDevelopers@yahoogroups.com Sent: Sunday, November 06, 2005 18:05 Subject: [AccessDevelopers] Changing font size in Report Hi All, I have a field in a report for a seminar attendee's name. Currently if the name runs over  15 characters it will go onto the next line and the person's name appears over 2 lines on the report. I would like it so that  the attendee's name is longer then x (in this case 15) characters then the font size drops back  - e.g. goes from 16 to 14 and the name remains on the single line Is this possible? Cheers Julian F Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.