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

ID: Q165050

The information in this article applies to:

SYMPTOMS

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

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.


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

For more information on the "Analyze It with MS Excel command, search the Help Index for "OfficeLinks," and then view "Load the output of a datasheet, form, or report into Microsoft Excel," or ask the Microsoft Access 97 Office Assistant. 


Keywords          : IntpOff IntpOlea 
Version           : 7.0 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 30, 1999