By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 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?

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


nico5038
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, ....
  2.  
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.