Font Size in Labels on Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Coope - 17 Mar 2007 00:39 GMT

How can I change the font size on a label in a form. There is no
obvious option (in 97').

I have tried font.size = 12 etc to no avail...

Cheers....

--
The Zero ST

Reply to this Message

Dave Peterson - 17 Mar 2007 00:53 GMT

This worked in xl2003:

Me.Label1.Font.Size = 12

> How can I change the font size on a label in a form. There is no
> obvious option (in 97').
[quoted text clipped - 5 lines]
> --
> The Zero ST

Signature

Dave Peterson

Reply to this Message

Craig Coope - 17 Mar 2007 02:37 GMT

>This worked in xl2003:
>
[quoted text clipped - 9 lines]
>> --
>> The Zero ST

Cheers for that...

OK I am a novice when it comes to VB but the font is only large after
I click on it...I assume it is to do with the coding for the label to
change when a user clicks on it but how do I get to to stay as I want
from the very start?

--
The Zero ST

Reply to this Message

Dave Peterson - 17 Mar 2007 02:43 GMT

Go into the VBE.
Show your userform
rightclick on the label
choose properties
Look for font in the properties window
Double click on the font name (Tahoma???)
Change the font size there

Remove any code that you used to specify the font size.

======
My bet is that you didn't have it in the correct procedure. I'm gonna guess
that you put it into some _click event. And I think userform_Initialize would
be better.

But once you change the properties, you can delete any code (well, unless you
really want to change it from the size you made it).

> >This worked in xl2003:
> >
[quoted text clipped - 19 lines]
> --
> The Zero ST

Signature

Dave Peterson

Reply to this Message