Microsoft KB Archive/127976

= ACC2: "Output To" Command Fails with Financial Functions =

Article ID: 127976

Article Last Modified on 11/6/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q127976





SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.

When you choose the Publish It With MS Word button or the Output To Rich Text Format command while you are previewing a report, you may receive the following error message:

Can't obtain this property setting. The property may not be available in this view, or an error has occurred.

If you choose the Analyze It With MS Excel button or the Output To Microsoft Excel command, you may receive the error message:

Can't evaluate expression.



CAUSE
These errors can occur if the report is based on a query containing a built-in financial function or if one of the text boxes in the report contains an error that returns the "#Error" message.



RESOLUTION
Perform the calculation using the financial function in the report itself, not in the query the report is based on. Also, make sure to fix any invalid expressions in the ControlSource property of any text box that returns the "#Error" message.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Problem
 Open a new database.  Create and save the following new table:

     Table: Table1 Field Name: Rate Data Type: Number Field Size: Single Field Name: Term Data Type: Number Field Size: Long Integer Field Name: Amount Data Type: Number Field Size: Long Integer   Enter the following data as the first record in Table1:

     Rate: 0.09 Term: 15 Amount: 573750   Create the following new query based on Table1:

<pre class="fixed_text">     Query: Query1 --     Type: Select Query Field: Rate Field: Term Field: Amount Field: Pmt([Rate],[Term],[Amount],0,0) </li> Run the query. Note that a negative number appears in the calculated field. Save the query as Query1 and then close it.</li> Select the Query1 query in the Database window and then choose the AutoReport button on the toolbar.</li> While you are previewing the new report, choose the Publish It With MS Word button on the toolbar. The first error message stated above occurs.</li></ol>

<div class="references_section">