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
    Commented Sep 29, 2016 at 4:23
  • Can you please give me full expression in Python
    – Abhay P
    Commented Sep 29, 2016 at 4:31
  • What happens when you use that code? Are there errors, or nothing appears, or everything appears?
    – Midavalo ♦
    Commented Sep 29, 2016 at 4:39
  • Other values appears but where Remarks is blank nothing appears
    – Abhay P
    Commented 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 you have read our privacy policy.

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