How not to show the '-' value of a Select Field List

[#1]

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

[#2]

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

[Sokkorn]

Hi,

Let use expression in your listbox

If(Len(Field)<1,Null(),[Field])

Regards,

Sokkorn

[#4]

Thanks but I would like the user not even see the values he can not select.

[#5]

Thanks but I would like the user not even see the values he can not select.

[#6]

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!!

[#7]

For stetic reasons I would like to show only the values I want that is 'Internacional', 'Locales', 'Gratuidades'.

[shree909]

Hi, Try this

if(len(trim(fieldname)<>0,fieldname)

or

=if(len(trim(Name))<>0,replace(Name,'-',''))

[#9]

i see, the response from Shree 909 its correct what you need!!!

Regards!!!!

[Gysbert_Wassenaar · Accepted solution]

Try: If(MyField <> '-', MyField)

or alternatively: if(match(MyField, 'Internacional', 'Locales', 'Gratuidades'),MyField)