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

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.

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

1. Start Microsoft Access 1.x and open the sample database NWIND.MDB. Open the Customers table in Datasheet view.
2. On the Layout menu, click Row Height. Change the value from 10.5 to 20.
3. Save the changes and quit Microsoft Access 1.x.
4. Start Microsoft Access 2.0, 7.0 or 97.

   In Microsoft Access 7.0 and 97 ------------------------------

5. On the File menu, click Open Database.
6. Choose the version 1.x database and click Convert in the Convert/Open Database dialog box.
7. Name the database NWINDC.MDB and click Save.

   In Microsoft Access version 2.0 -------------------------------

8. On the File menu, click Convert.
9. Convert the Microsoft Access version 1.x sample database NWIND.MDB to version 2.0 format.
10. Name the converted database NWINDC.MDB

    In Microsoft Access 2.0, 7.0, and 97 -----------------------------------

11. Open the NWINDC database, and then open the Customers table in Datasheet view.
12. 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.

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