Microsoft KB Archive/165050

= ACC: Bold Font Style Not Exported Using Analyze It With MS Excel =

Article ID: 165050

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q165050



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 7.0 or 97 to Microsoft Excel 7.0 or 97 by using 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
Most formatting, such as regular and italic font styles and colors, is preserved when you export data to Microsoft Excel by using the "Analyze It with MS Excel" command. However, bold font styles are not preserved.



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



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 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.

