Is there any way, combo box does not show NULL (BLANK) values?
Country $$
USA 500
CANADA 300
BLANK NULL
ENGLAND 200
I had created Combo box filter based on Country column and I do not want BLANK value in Combo box.
Philip (BOB member since 2006-03-02)
Yes it is possible. Go to the combo box properties–> Go to the behaviour Tab–>Check the option “Ignore Blank Cell” In Values.
Your problem will be resolved.
-Romit.
romit 
(BOB member since 2011-05-05)
Hi all,
I think Philip problem is somewhat different from what Romit said… Romit what philip asks is to eliminate Blank values which comes inbetween the cells which has values… But “Ignore Blank cells” will eliminate blank cells at the end of range only!!!
Regards,
MMK
mmk2107 (BOB member since 2012-01-25)
If that is what Philip is asking, we can eliminate the null values at the QaaWs definition(If he is using QaaWs as his Connection string). For Eg:- In the QaaWs definition, drag the same object as a filter, use the Object is not Null. This will solve the problem of handling null at the QaaWs level itself.
If Philip is using a WebI report and using the report via Live Office connection, then in the report level itself, we can handle the null values.Its similar as QaaWs, drag the same object as query filter and say it not null.
-Romit.
romit (BOB member since 2011-05-05)
You are right MMK. Whatever you said that is my requirement.I need to eliminate BLANK cell is excel not in Qaaws or universe.
Philip (BOB member since 2006-03-02)
Can’t you just sort by value (or add an order onto your query) - the null drops to the bottom and you check the “Ignore Blank Cells” option. This will ignore the ones at the end.
Debbie
Debbie 
(BOB member since 2005-03-01)
I am calculating second combo box values in Excel sheet. I meant whatever user select from first combo box (which is Country) it;s associated value (here State) will show in second combo box. I am using VLOOKUP excel function for this calculations.
Philip (BOB member since 2006-03-02)
Yes, but where are your countries coming from for your first combo? If it’s a connection, then add a sort into the query behind it. If they are typed into excel, then sort manually first. Then check the box not to display blanks.
Debbie
Debbie (BOB member since 2005-03-01)