Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 224
Default Label controls change apparent font size when moved up/down

Some of my label controls change their apparent font size when moved
to a different Top property on the form during runtime. Others do not.

All the label controls are set in design-time to have a font size of
9. For the problem label controls, even if I explicitly set them to 9
in run-time after moving them, they still display as what appears to
be a font size of 10. Even if I change the font size to 8, and then to
9 -- or to 10, then to 9 -- in run-time after moving them, they still
display as what appears to be font size 10.

When I check the problem label control's font.size property, it
reports the font size it should have (9), not the larger font size
that it displays as (10).

I don't see any difference in the label properties. I tried copying
one of the label controls that did not have the problem, and changed
its name and caption to replace one of the problem label controls, and
deleted the original problem label control. But the problem was still
there.

I tested in Excel 2010, 2007, 2003, 2002, and 2000, and all had the
same problem. I tried 97 too but my project is not compatible with it,
so I'm not sure if 97 has the same problem.

For the label controls that are affected by the problem, the problem
occurs when I change the label control's Top property during runtime.
If I don't change the control's Top property, the problem does not
happen for that control.

Any idea why this problem is happening, and what I can do about it?


Thanks,

Greg
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Label controls change apparent font size when moved up/down

Greg Lovern presented the following explanation :
Some of my label controls change their apparent font size when moved
to a different Top property on the form during runtime. Others do not.

All the label controls are set in design-time to have a font size of
9. For the problem label controls, even if I explicitly set them to 9
in run-time after moving them, they still display as what appears to
be a font size of 10. Even if I change the font size to 8, and then to
9 -- or to 10, then to 9 -- in run-time after moving them, they still
display as what appears to be font size 10.

When I check the problem label control's font.size property, it
reports the font size it should have (9), not the larger font size
that it displays as (10).

I don't see any difference in the label properties. I tried copying
one of the label controls that did not have the problem, and changed
its name and caption to replace one of the problem label controls, and
deleted the original problem label control. But the problem was still
there.

I tested in Excel 2010, 2007, 2003, 2002, and 2000, and all had the
same problem. I tried 97 too but my project is not compatible with it,
so I'm not sure if 97 has the same problem.

For the label controls that are affected by the problem, the problem
occurs when I change the label control's Top property during runtime.
If I don't change the control's Top property, the problem does not
happen for that control.

Any idea why this problem is happening, and what I can do about it?


Thanks,

Greg


Could you be seeing a copy of a label. The copy would not change if
you're not referencing it at runtime.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 587
Default Label controls change apparent font size when moved up/down

hi Greg,

have you tested all versions xl on the same PC?
i ask because you said "display as"
i think the problem could come from the graphics card or one of drivers


--
isabelle

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 224
Default Label controls change apparent font size when moved up/down

On May 13, 7:34*pm, isabelle wrote:
hi Greg,

have you tested all versions xl on the same PC?
i ask because you said "display as"
i think the problem could come from the graphics card or one of drivers


Hi Isabelle,

Thanks, you were right. I tried it on another computer, and it works
fine there.

Greg
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you change the font and font size for a forms control ? exceluser Excel Programming 4 October 29th 10 02:27 AM
Change font and/or font size in headers, footers and body via VBA BEEJAY Excel Programming 1 December 7th 09 07:36 PM
Font size on ActiveX controls Fred Excel Programming 0 August 5th 08 11:08 PM
changing font size in an activex label TONY Excel Programming 1 December 20th 07 06:59 AM
Change all text one font size up with various font sizes used. omchrystal New Users to Excel 2 March 6th 07 09:01 PM


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"