Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have this Field and I would like not to show the empty value ('-').
There is no empty value in the table but in the related ones by a key field.
Anyway I would like the user can not select '-'.
Thanks
Try: If(MyField <> '-', MyField)
or alternatively: if(match(MyField, 'Internacional', 'Locales', 'Gratuidades'),MyField)
there are two ways:
1.- Select the '-' character after Rigth Clik over LIST BOX and choose Select Excluded option
2.- To level script
If(Nom_field <> '-',Nom_field)
regards!!!
or attach the qvw
Hi,
Let use expression in your listbox
If(Len(Field)<1,Null(),[Field])
Regards,
Sokkorn
Thanks but I would like the user not even see the values he can not select.
Thanks but I would like the user not even see the values he can not select.
we unterstand the user not to see the values with simbol '-' but
how do you know what values the users have not to see?
explain plis!!
For stetic reasons I would like to show only the values I want that is 'Internacional', 'Locales', 'Gratuidades'.
Hi, Try this
if(len(trim(fieldname)<>0,fieldname)
or
=if(len(trim(Name))<>0,replace(Name,'-',''))
i see, the response from Shree 909 its correct what you need!!!
Regards!!!!
Try: If(MyField <> '-', MyField)
or alternatively: if(match(MyField, 'Internacional', 'Locales', 'Gratuidades'),MyField)