How to programaticly change the display font size for tables

[Guest]

A database I inherited was developed by someone who thought font size 5 was a
good size for everyone to read (I think he liked squinting); Nevertheless,
he's gone (for good reason) and I'm stuck with having to open each table and
select Format - Font - Size 10. Not an impossible task, but I'm lazy and
would rather use code to cycle thru the 50 plus tables, if it's possible.

I'm put together a little code that cycles thru and gives me the table
names, but I'm stuck on how to "open", and change the formatting / font size.

Any help is appreciated.

 

[ruralguy via AccessMonster.com]

I believe this is just a display option. What happens when you go to
Tools>Options...>Datasheet tab and change the Default font size?

 

[Guest]

I believe Tools - Options sets the default font size for any future tables,
which means any new tables would have the revised font size; But existing
tables don't.

 

[fredg]

A database I inherited was developed by someone who thought font size 5 was a
good size for everyone to read (I think he liked squinting); Nevertheless,
he's gone (for good reason) and I'm stuck with having to open each table and
select Format - Font - Size 10. Not an impossible task, but I'm lazy and
would rather use code to cycle thru the 50 plus tables, if it's possible.

I'm put together a little code that cycles thru and gives me the table
names, but I'm stuck on how to "open", and change the formatting / font size.

Any help is appreciated.

Look up (in VBA help)

DatasheetFontHeight Property

There is sample code there.

 

[ruralguy via AccessMonster.com]

I tried it in my acXP and the Datasheet view of a table changes with the
setting. Not so with what you are using?

I believe Tools - Options sets the default font size for any future tables,
which means any new tables would have the revised font size; But existing
tables don't.

I believe this is just a display option. What happens when you go to
Tools>Options...>Datasheet tab and change the Default font size?

[quoted text clipped - 9 lines]

 

[Van T. Dinh]

Datasheet View of *existing* Tables should change when you set the Font Size
in in Tools / Options ... / Datasheet tab.

However, The DatasheetView of the Forms is not affected by this setting and
this may be what you observed rather than what "ruralguy" advised. If this
is the case, see Fred's advice ...