Programmatic setting of fonts in datasheet view is carried out via form's DatasheetFont group of properties.
 
    Sample code block given below handles the settings for datasheet subform in container control named SF_01.
 
A.D.Tejpal
 
===================================
With SF_01.Form
    .DatasheetFontHeight = 12
    .DatasheetFontItalic = True
    .DatasheetFontUnderline = False
    .DatasheetFontWeight = 800  ' (Range - 100 to 900)
    .DatasheetForeColor = 8388608    ' Navy Blue

End With
===================================
 
----- Original Message -----
Sent: Saturday, September 10, 2005 17:59
Subject: [AccessDevelopers] Datasheet font size

I have a number of forms which by default are viewed in Datasheet view.   How can I change the font size in this view for these forms?

I know you can change the default under Tools/Options but that is only for new forms and I do not want to build my database from scratch again!

Thanks for any help.



Please zip all files prior to uploading to Files section.




SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming


YAHOO! GROUPS LINKS




Reply via email to