How to programaticly change the display font size for tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Knight - 09 Mar 2007 22:56 GMT

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.

Signature

Dan Knight

Reply to this Message

ruralguy - 09 Mar 2007 23:39 GMT

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

>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,
[quoted text clipped - 6 lines]
>
>Any help is appreciated.

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Dan Knight - 10 Mar 2007 01:10 GMT

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.

Signature

Dan Knight

> 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]
> >
> >Any help is appreciated.

Reply to this Message

ruralguy - 10 Mar 2007 01:22 GMT

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
[quoted text clipped - 5 lines]
>> >
>> >Any help is appreciated.

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Van T. Dinh - 10 Mar 2007 04:29 GMT

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 ...

Signature

HTH
Van T. Dinh
MVP (Access)

>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.

Reply to this Message

fredg - 10 Mar 2007 01:19 GMT

> 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,
[quoted text clipped - 6 lines]
>
> Any help is appreciated.

Look up (in VBA help)

DatasheetFontHeight Property

There is sample code there.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message