I have a simple report that displays a number of fields. I need to modify one date field: RMAReceiptDate and am unsure how to do this.
When an item is received the date is entered in RMAReceiptDate. This date is properly displayed on the report. However, if an item has not been received, there is no data in the table to display and the report field is blank. Instead of a blank space, I would like the report to state Not Received.
I tried entering NZ ([RMAReceiptDate], "Not Received") in the control source on the property sheet. The report displays #Size! instead of Not Received and I see a invalid control property circular reference error asterisk next to the field in design view.
I also tried using conditional formatting rule with the following "Expression": NZ ([RMAReceiptDate], "Not Received") However, this is also not working.
Any suggestions on what I am doing wrong?
Thank you.
When an item is received the date is entered in RMAReceiptDate. This date is properly displayed on the report. However, if an item has not been received, there is no data in the table to display and the report field is blank. Instead of a blank space, I would like the report to state Not Received.
I tried entering NZ ([RMAReceiptDate], "Not Received") in the control source on the property sheet. The report displays #Size! instead of Not Received and I see a invalid control property circular reference error asterisk next to the field in design view.
I also tried using conditional formatting rule with the following "Expression": NZ ([RMAReceiptDate], "Not Received") However, this is also not working.
Any suggestions on what I am doing wrong?
Thank you.