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/
 


Reply via email to