ACC2000: Bold Font Style Not Exported Using Analyze It with MS Excel (207790)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q207790
This article applies only to a Microsoft Access database (.mdb).

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

SYMPTOMS

If you format data in a table with a bold font style, and you then export the table from Microsoft Access to Microsoft Excel by using the Analyze It with MS Excel command or by clicking Export on the File menu, the bold font style is replaced by a regular font style.

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

RESOLUTION

If you need the data to be formatted as bold in Excel, you must apply the format to the data after you export it.

MORE INFORMATION

Most formatting, such as regular and italic font styles and colors, is preserved when you export data to Excel.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  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 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. Excel automatically starts and opens the Table1 table.
  8. View the format of the data in Excel. Note that it has been changed from a bold font style to a regular font style.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug KB207790
©2004 Microsoft Corporation. All rights reserved.