Microsoft KB Archive/117538

{|
 * width="100%"|

PRA: 1.x Table/Query Datasheet Properties Not Converted
'Article ID: Q117538

Creation Date: 30-JUN-1994

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


 * Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

The row heights and fonts of tables and queries open in Datasheet view that were converted from Microsoft Access 1.x format to Microsoft Access 2.0, 7.0 or 97 format are reset to their default values. The row heights and fonts are not set to what they were in Microsoft Access 1.x.

CAUSE

When you convert a database from Microsoft Access 1.x to Microsoft Access 2.0, 7.0, or 97 format, the following property settings for tables and queries are reset to their default values:


 * Description
 * FrozenColumns
 * RowHeight
 * DatasheetFontHeight
 * DatasheetFontItalic
 * DatasheetFontName
 * DatasheetFontUnderline
 * DatasheetFontWeight

RESOLUTION

There are two ways to work around this problem:


 * After converting the database, manually set each of the affected properties back to the correct setting by using the commands on the Format menu.
 * Write a custom function to automatically set the datasheet properties for each table. The SetTableProperty procedure demonstrates how to set the row height of the Customers table in the sample database Northwind.mdb to display two lines of data. The property setting will take effect the next time you open the Customers table in Datasheet view. The SetTableProperty procedure can be found in Microsoft Access Help. To see this function, search for DatasheetFontItalic property," then click "Example," using the Microsoft Access Help Index.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 2.0, 7.0, and 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

 Start Microsoft Access 1.x and open the sample database NWIND.MDB. Open the Customers table in Datasheet view. On the Layout menu, click Row Height. Change the value from 10.5 to 20. Save the changes and quit Microsoft Access 1.x. Start Microsoft Access 2.0, 7.0 or 97. In Microsoft Access 7.0 and 97 -- On the File menu, click Open Database. Choose the version 1.x database and click Convert in the Convert/Open Database dialog box. Name the database NWINDC.MDB and click Save. In Microsoft Access version 2.0 --- On the File menu, click Convert.</li> Convert the Microsoft Access version 1.x sample database NWIND.MDB to version 2.0 format.</li> Name the converted database NWINDC.MDB In Microsoft Access 2.0, 7.0, and 97 ---</li> Open the NWINDC database, and then open the Customers table in Datasheet view.</li> Check the row height setting that you set in step 2. Note that the value has been reset to the default setting instead of your saved 20 setting.</li></ol>

REFERENCES

For more information about Datasheet properties, search the Help Index for "DatasheetFontHeight property," or ask the Microsoft Access 97 Office Assistant.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED 'AS IS' 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: TblOthr

Additional reference words: 2.00 7.00 97 8.00