0

Below expression is not working

Function FindLabel ( [NameEnglish], [Remarks], [FacilityType] )
    namh = ""
    rems = ""
    fact = ""    

    if not isnull (  [NameEnglish] )  then
        namh = [NameEnglish]
     elseif not isnull  (  [Remarks] ) or (([Remarks]) <> "")  then
        rems = [Remarks]
      elseif not isnull (  [FacilityType] ) then
        fact = [FacilityType]
    end if

    FindLabel = namh & " " & rems & " " & fact
End Function

I want to fulfill condition when Remarks is NULL & Remarks having "" means blank

Improve this question
4
  • Python works better with null values, use [field] == None for this condition.
    – Michael Stimson
    Sep 29, 2016 at 4:23
  • Can you please give me full expression in Python
    – Abhay P
    Sep 29, 2016 at 4:31
  • What happens when you use that code? Are there errors, or nothing appears, or everything appears?
    – Midavalo ♦
    Sep 29, 2016 at 4:39
  • Other values appears but where Remarks is blank nothing appears
    – Abhay P
    Sep 29, 2016 at 5:22

1 Answer 1

Reset to default
2

change the or to an and

elseif (not isnull ([Remarks])) and ([Remarks] <> "") then
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.