By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

Access Report - How do you hide 'null' data and labels?

P: 8
I am designing a number of reports for my system and have used the following method for when there is no data in particular fields:
Label is called UNPAID TIME
Change the label to - Textbox
Textbox Control Source type in: =IIf([UNPAID TIME] Is Null, Null, "UNPAID TIME")

When I used this method, the Textbox disappears even when there is data in the field. Am I doing something wrong here?
Also, is there any way to hide the backcolour of the textbox/label when there is null values?

May 18 '12 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
I would change the query the repost is based on to hold the resultfield like:
Expand|Select|Wrap|Line Numbers
  1. SELECT IIF(LEN(NZ([UNPAID TIME]))>0, "UNPAID TIME",NULL) as UnpaidText, ....
It's possible that an empty field contains an empty string instead of NULL, thus the above test will capture both situations.

Now you can use the field UnpaidText in your report.
May 18 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.