If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Null values in List Boxes
I have placed List boxes in a report that each show a sum
from seperate queries, but when there are no results from the queries, the field is left blank in the report (Null). I would like those convert those "Null" values to display a "0". I have tried to use the IIf function and Nz([control]) function in the query, but that doesn't work. Is there some code I can use on the "on Format" property of the detail section to, perhaps an If statement, to make these controls display a "0" when they are null? Is this possible with List boxes? Thanks |
#2
|
|||
|
|||
Null values in List Boxes
Rather than using a listbox in a report, consider using a subreport.
-- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to list unique values in an arryay | Dan S | General Discussion | 4 | June 22nd, 2004 03:29 AM |
Multible selection in list boxes | Logi Huldar | New Users | 2 | June 15th, 2004 12:49 PM |
Blanks vs. Null values in Functions | Worksheet Functions | 1 | October 17th, 2003 12:02 PM | |
list of values include old non valid data | zeyad alhekail | Worksheet Functions | 1 | October 16th, 2003 12:17 AM |