Report (2003)

Topic

New Reply

Hi,

I have a monthly data report. Some number in the field is “0”. Is any way to show a note such as “Empty Information” if the number is “0” in the report?

Thanks

Reply | Quote

Replies

Set the Control Source of the text box to

=IIf([NameOfField]=0,"Empty Information",[NameOfField])

where NameOfField is the name of the field.

Important: Change the name of the text box to something different from the name of the field. Access gets confused if the control source is an expression that refers to the same name as the name of the text box.

Reply | Quote

Thanks.

If I want to show both “Enter Information” with “0” and “Enter amount” with “1”?

Regards

Reply | Quote

Why would you do that on a report? A report is not interactive, the user cannot enter anything.

Reply | Quote

I am sorry for unclear information.

User enter the nubmer, but my boss want see one report with the meaning of the nubmer. So I find out the esay way is to do change on the report. I don’t want to change on query since other reports need to show the numbers that user enter.

So for this report, I need able to show if number is “0” report show “Enter Information,” if number is “1” report show “Enter amount”.

I tried put the following code, but it’s not working.

=IIf([UNIT]=0,”Enter Informatioin”,[UNIT] or [UNIT]=1,”Enter amount”,[UNIT] )

Please help!!!

Thanks

Reply | Quote

Try

=IIf([Unit]=0,"Enter Information",IIf([Unit]=1,"Enter Amount",[Unit]))

Reply | Quote

It works.

Thanks a lot

Regards

Reply | Quote