Thank you AD. Looks like this is just what I need Cheers Julian F
A.D.Tejpal wrote: > *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 <mailto:[EMAIL PROTECTED]> > *To:* [email protected] > <mailto:[email protected]> > *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 > <http://groups.yahoo.com/group/AccessDevelopers>" on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------------------------------------------------ > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
