isNull(fieldName) is true if select more than one value from fieldName

[Anonymous]

Hi, all, I am confused of using IsNull here when I use IsNull() to check whether there value from a fieldName is selected or not.

I can understand that if no selection of fieldName, then IsNull(fieldName) is true, but when I select more than one value from the fieldName, the result is also true, which I expect be false.

If that is the case, then how can I identify there is no selection of a field? I need to use the result as a condition to show other object.

Thank you very much~

[Aurelien_Martinez · Accepted solution]

Hi,

Try this GetSelectedCount(fieldName) > 0

Aurélien

[simondachstr]

isNull(FieldName) will evaluate to True and is working as designed.

Reason being is that for one row (or in a textbox) FieldName will have multiple values (if you select more than one value). Since FieldName is not deterministic (it can have more than one value) it returns null() or '-'. IsNull() of null() is true.

If you wish to identify if there are no selections in a field, use GetSelectedCount(Fieldname)=0 as Aurelien suggested.

[Anonymous]

@Martin,

It works!!! Thanks very much for your explanation.

Zhihong