Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you change the font and font size for a forms control ? | Excel Programming | |||
Change font and/or font size in headers, footers and body via VBA | Excel Programming | |||
Font size on ActiveX controls | Excel Programming | |||
changing font size in an activex label | Excel Programming | |||
Change all text one font size up with various font sizes used. | New Users to Excel |