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?
donvike1Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:


Private Sub Form_Load()
    With Me
      '  .DatasheetFontName = "Arial"
        .DatasheetFontHeight = 11   ' change to 11 from whatever
    End With
   
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
How about this:

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

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.