ACC: Bold Font Style Not Exported Using Analyze It w/MS Excel

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

When you export the data in a table that has been formatted using a bold font style from Microsoft Access 7.0 or 97 to Microsoft Excel 7.0 or 97, with the "Analyze It with MS Excel" command, the bold font style is replaced by a regular font style.

If you export the same table to Microsoft Word 7.0 or 97, the bold font style is not changed.

CAUSE

Exporting data to Microsoft Excel using the "Analyze It with MS Excel" command preserves most formatting, such as regular and italic font styles and colors. However, bold font styles are not preserved.

RESOLUTION

To ensure that the data you export to Microsoft Excel is displayed in a bold font style, you must format the data after it is exported.

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb in Microsoft Access 7.0 or 97.

2. Create a new table and add a text field to the table. Name the text field Field1 and save the table as Table1.

3. Switch the Table1 table to Datasheet view and type "a" (without the quotation marks) in the first record of the Field1 field.

4. Highlight the Field1 field, and then on the Format menu, click Font.

5. In the Font dialog box, in the Font Style box, click Bold, and then click OK.

6. Close the Table1 table.

7. On the Tools menu, point to OfficeLinks, and then click "Analyze It with MS Excel." Microsoft Excel automatically starts and opens the Table1 table.

8. View the format of the data in Microsoft Excel. Note that it has been changed from a bold font style to a regular font style.

REFERENCES