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

ID: Q207790

The information in this article applies to:
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: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform 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.


Additional query words: pra 


Keywords          : kbdta IntpOff IntpOlea 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 14, 1999