XL2000: Text Problems in Controls When Worksheet Is Zoomed (211866)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211866

SYMPTOMS

In Microsoft Excel 2000, when you insert a control from the Control Toolbox toolbar in a worksheet, you may notice any of the following problems:
  • The font size of any text attached to a control, such as a check box, an option button, or a button, suddenly increases when you click the control. This prevents you from viewing all of the text attached to the control.
  • When you enter text in a text box or a combo box, the text becomes compressed when you click another control or a cell in the worksheet.
  • Text in list boxes is compressed vertically. This prevents you from viewing text in the list box.
  • Text in labels is compressed and unreadable, except when you click the label and leave the pointer positioned over the label.

CAUSE

These problems occur if all of the following conditions are true:
  1. You view the worksheet with a Zoom setting of less than 100 percent.

    -and-
  2. The worksheet is not in design mode.
As the Zoom setting decreases towards the minimum (10 percent), the problems become more noticeable. NOTE: These problems do not occur when the Zoom setting for the worksheet is between 100 and 400 percent.

WORKAROUND

To work around this problem, click Zoom on the Standard toolbar to increase the Zoom setting to a value equal to or greater than 100 percent.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

You can use the Control Toolbox toolbar to insert a control in a worksheet. By default, the following controls are available on the Control Toolbox toolbar: 

   Check Box          Option Button
   Combo Box          Scroll Bar
   Command Button     Spin Button
   Image              Text Box
   Label              Toggle Button
   List Box

Although you can use these controls in worksheets, text attached to these controls does not appear properly if you zoom the worksheet that contains them to a setting of less than 100 percent.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB211866
©2003 Microsoft Corporation. All rights reserved.