[AccessD] VBA Font Size

Bob Heygood accesspro at gmail.com
Sun May 21 14:50:51 CDT 2017


Yes.
I have monkeyed with a lot of my screen settings though the years.

And don't do so much VBA work now. 
BUT it sure would be cool to fix this 

Thanks again

Bob

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Saturday, May 20, 2017 6:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA Font Size

Sorry, just saw you already told us it was Office 2010. Anyway it still
could be screen resolution setting. But I don't see how... also people
referring to registry settings, but even manually changing those, they got
reset afterwards by the application (or something that interacts with the
application.)

On Sat, May 20, 2017 at 9:05 PM, Bill Benson <bensonforums at gmail.com> wrote:

> I am seeing multiple postings on this subject. Bob what Ac version are 
> you using?  Are you working on a laptop? Someone seemed to think it 
> has to do with screen resolution, picking larger fonts that the screen 
> doesn't want to show in certain resolution modes.
>
> I didn't read all of this, but you might have a look here 
> <https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso
>
_win10/font-size-in-vba-editor-in-excel-2016/2f51c62d-bf74-4029-92ee-5aaebc2
92e39> and here
<https://www.access-programmers.co.uk/forums/showthread.php?t=292248>:
> I think one person (Ac2016) found a workable solution and the other 
> did not (Ac2010).
>
>
> On Sat, May 20, 2017 at 8:55 PM, Stuart McLachlan 
> <stuart at lexacorp.com.pg>
> wrote:
>
>> Strange.
>>
>> Same environment as me Office 2010 + M-Z Tools and I have no problem 
>> changing the fotn size.
>>
>> Does the actual font change if you go to something like Consolas 
>> (Western)?  i.e. is the complete font setting of just the size that 
>> is locked?
>>
>>
>>
>> On 20 May 2017 at 17:06, Bob Heygood wrote:
>>
>> > I tried Courier New. No joy.
>> > Still reverts to font of 9 points.
>> >
>> > Office 2010
>> > M-Z Tools installed
>> >
>> > Bob
>> >
>> >
>> > -----Original Message-----
>> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On 
>> > Behalf Of Bill Benson Sent: Friday, May 19, 2017 11:08 PM To: 
>> > Access Developers discussion and problem solving Subject: Re: 
>> > [AccessD] VBA Font Size
>> >
>> > Me too.
>> >
>> > From my non-flammable Note 3,
>> > Bill Benson
>> >
>> > On May 19, 2017 5:19 PM, "Stuart McLachlan" 
>> > <stuart at lexacorp.com.pg>
>> > wrote:
>> >
>> > > Arial is a problem for code because it is variable width.
>> > >
>> > > I use Courier New. It is fixed width and lets you pick the size.
>> > >
>> > > And I think it looks a lot nice than Fixedsys :-)
>> > >
>> > > --
>> > > Stuart
>> > >
>> > >
>> > > On 19 May 2017 at 13:22, Steve Conklin wrote:
>> > >
>> > > > It depends on the font: Arial can do any size but Fixedsys (my 
>> > > > choice in VBA) does  9 only.
>> > > >
>> > > >
>> > > > hth,
>> > > >
>> > > > Steve Conklin
>> > > >
>> > > >
>> > > > ________________________________
>> > > > From: AccessD <accessd-bounces at databaseadvisors.com> on behalf 
>> > > > of Bob Heygood <accesspro at gmail.com> Sent: Friday, May 19, 2017 
>> > > > 9:01 AM To: 'Access Developers discussion and problem solving'
Subject:
>> > > > Re: [AccessD] VBA Font Size
>> > > >
>> > > > The failure is across the board. Excel also lets me change the 
>> > > > font type but not the size... Office 2010
>> > > >
>> > > >
>> > > > Thx
>> > > > Bob
>> > > >
>> > > >
>> > > > -----Original Message-----
>> > > > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On 
>> > > > Behalf Of Bill Benson Sent: Thursday, May 18, 2017 8:46 PM To:
>> > > > Access Developers discussion and problem solving Subject: Re:
>> > > > [AccessD] VBA Font Size
>> > > >
>> > > > So the setting is noticed in other VBA (office) editors, just 
>> > > > not Access?
>> > > >
>> > > > From my non-flammable Note 3,
>> > > > Bill Benson
>> > > >
>> > > > On May 18, 2017 11:44 PM, "Bob Heygood" <accesspro at gmail.com>
>> > > > wrote:
>> > > >
>> > > > > Why does Access ignore my settings when I change the font 
>> > > > > size in the VBA editor ? Could it be MZ Tools ? My old eyes 
>> > > > > are strained.
>> > > > >
>> > > > >
>> > > > > Bob Heygood
>> > > > >
>> > > > > --
>> > > > > AccessD mailing list
>> > > > > AccessD at databaseadvisors.com
>> > > > > http://databaseadvisors.com/mailman/listinfo/accessd
>> > > > > Website: http://www.databaseadvisors.com
>> > > > >
>> > > > --
>> > > > AccessD mailing list
>> > > > AccessD at databaseadvisors.com
>> > > > http://databaseadvisors.com/mailman/listinfo/accessd
>> > > > Website: http://www.databaseadvisors.com
>> > > >
>> > > > --
>> > > > AccessD mailing list
>> > > > AccessD at databaseadvisors.com
>> > > > http://databaseadvisors.com/mailman/listinfo/accessd
>> > > > Website: http://www.databaseadvisors.com
>> > > > --
>> > > > AccessD mailing list
>> > > > AccessD at databaseadvisors.com
>> > > > http://databaseadvisors.com/mailman/listinfo/accessd
>> > > > Website: http://www.databaseadvisors.com
>> > > >
>> > >
>> > >
>> > > --
>> > > AccessD mailing list
>> > > AccessD at databaseadvisors.com
>> > > http://databaseadvisors.com/mailman/listinfo/accessd
>> > > Website: http://www.databaseadvisors.com
>> > >
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > http://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > http://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list