Microsoft KB Archive/95805

{|
 * width="100%"|

PRB: Unfreeze All Columns Does Not Restore Column Order
'Article ID: Q95805

Creation Date: 25-FEB-1993

Revision Date: 01-DEC-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

If you view a table, a query, or a form in Datasheet view, and then click Freeze Columns on the Format menu (or Layout menu in Microsoft Access version 1.x), the column that your pointer is in moves to the far left and is separated by a bold black bar, as expected. However, when you click Unfreeze All Columns on the Format menu, the original order of the columns is not restored.

RESOLUTION

When you unfreeze columns in Datasheet view of a table, a query, or a form, you must manually restore the order of the columns if you want to display them differently. Follow these steps to reorder the columns:


 * 1) Open the table, query, or form in Datasheet view.
 * 2) Select the column you want to move by clicking the column heading. This highlights the entire column.
 * 3) Click again in the column heading and drag the column left or right to the desired position.

STATUS

This behavior is by design.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbusage

KBSubcategory: FmsProp

Additional reference words: 1.00 1.10 2.00 7.00 97 8.00