Modify Access Tables thru VBA

[loudenkl]

I am looking for away to modify the layout of Access tables thru VBA. What I want to accomplish is to change the default font type and size.
I know that I can use DoCmd.RunCommand acCmdFont and this will pull up the FONT window where I can manually select the FONT type and size - but is there a way handle this automatically?
thanks,
K Louden

 

[MHM]

Hi loudenkl,

do you really need to change an Access-(Application-)setting (locally stored in profile, not bound to any mdb!!).
Normally you only set fonts for forms, queries and reports - there you can choose from a wide variety.
In case you really want to do it as you've described: Do menu
Tools/options, register Datasheet, fontSize XX

Mic