Filter listbox

[n1ef5ng1]

Hi gurus,

I have a country field where it has all the countries in the world (200+),

In this particular table, it only applies to ten countries and i would like to filter the list box just for the 10 countries.

This can be done on listbox, expression.

However, I am facing a problem on fields that is like, China,Asia. Those fields that contain comma does not work.

if(Country = China,Asia,'China')

if (Country = China & Chr(44) & Asia,China,

Both of the code does not work. *note, countries that do not have comma in the field will not have this problem

Thanks

[jagan]

Hi,

Try like this

if(Country = 'China,Asia','China')

If not working can you attach some sample data and output.

Regards,

Jagan.