Link to home
Start Free TrialLog in
Avatar of donvike1
donvike1Flag for United States of America

asked on

How do I change the fonts within a subform

I have a subform within a form
I would like to change the fonts to a 8 instead of a 11.
I have change the fonts within the property of the subform as well as the fields.
How do I make the subform go to a smaller font?
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

How about this:

Private Sub Form_Load()
    With Me
        .DatasheetFontName = "Arial"
        .DatasheetFontHeight = 10
    End With
   
 
   
End Sub

mx
Good reference for datasheet subforms - changing properties:


Michael Kaplan Smart Access article:
You Can Do That with Datasheets
http://msdn2.microsoft.com/en-us/library/aa217449.aspx   

mx
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial