Results 1 to 7 of 7

Thread: Report (2003)

  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report (2003)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report (2003)

    Set the Control Source of the text box to
    <code>
    =IIf([NameOfField]=0,"Empty Information",[NameOfField])
    </code>
    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.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2003)

    Thanks.

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

    Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report (2003)

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

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2003)

    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

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report (2003)

    Try
    <code>
    =IIf([Unit]=0,"Enter Information",IIf([Unit]=1,"Enter Amount",[Unit]))</code>

  7. #7
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2003)

    It works.

    Thanks a lot

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •