How to disable the items on selection box which dont have any data?

[anindya_manna]

Hi,

I have a month selection box.Suppose for month of nov and dec i dont have any data.While selecting on those month individually the selection is disable and nothing display in current selection box.

But if i press CTRL key and select multiple month including nov or dec then those value are displaying in current selection box.

How to overcome it?I dont want to show the month name which dont have any data in current selection box whille pressing CTRL key.

[#2]

Hi anindya,

Use expression in ListBox to show months which have values.

=if(Value>0, Month(Date#(Cal_Date,'DD-MM-YY')))