Error on Report value

[tnesbit]

Hi Guys, I know I'm missing something but I don't know what it is.

I have added the following code to the Control Source (in properties) for a report. I have also added the same code to 2 other fields in the same report with no problem. The field (SettlementAssets) is defined as number and the format is #,##0;(#,##0) (as are the 2 other fields).

The field is displaying as #ERROR on the report. I replaced the field in question with another field name (DisburseBP) and had no problem, the field (DisburseBP) displayed fine.

=([SettlementAssets])*-1

What am I missing?!@#^$&

Thanx much,
Trudye

 

[genomon]

Why do you want a calculated field as the control source of a report object?

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[tnesbit]

genomon,
all of the fields on the form are unbound, and I want the field to be reflected as (200).

This process has worked for all the other fields. Why is it not working for this one??

 

[genomon]

The control source for a REPORT has to be some type of dataset such as a table or query that CONTAINS the field
SettlementAssets. If this is a text box or other CONTROL, then this error usually means that [SettlementAssets] is not part of the REPORT source, or that the field name on the table/query is spelled differently than the one used in your code. If the latter may be the case, go back and compare field name spellings. Other than that I am stumped, and would suggest a cold beer....

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[tnesbit]

Thanx genomon for responding. Field spelling was one of the first things I checked. I copied and pasted the field name directly from the table.

I'm stumped too, thanks anyway.

 

[PHV]

And what about this ?
=Nz([SettlementAssets],0)*-1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tnesbit]

Hi PHV, thanks for weighing in. It's funny you should suggest that I thought about that last night and planned on trying it this AM.

However it did not work, I still get the error. If I just place the field name (IE. SettlementAssets) I get a numeric value of 130,130. I tried removing the *-1 and leaving the NZ() and I still get the error. There is no pleasing this field name. If I replace is with another field name it displays with no problem.

Obviously this field is possessed. If you can think of a way to exercise it please let me know. (smile)

Thanx again,
Trudye

 

[PHV]

what is the ControlSource of SettlementAssets ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tnesbit]

Hi PHV; The control source for SettlementAssets is its fieldname. The control source for the report is a SQL statement behind the subform that SettlementAssets resides on.

Properties Layout
Name:SettlementAssets
Control Source:SettlementAssets
Format: #,##0;(#,##0)
Decimal Places: 0
Input Mask:
Running Sum: No

Thank you so much for your patience,
Trudye