Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Jan 19, 2025
Solved

#Error in unbound text box

Hello Experts, I am trying to display nothing instead of #Error being displayed in an unbound text box.  Its only showing on the new record row.  The below is not working.  It still displays #Erro...
access
  • Gustav_Brock's avatar
    Gustav_Brock
    Jan 20, 2025

    Use Nz to return a non-existing value for letterOfCreditID if it is Null:

    =DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & Nz([letterOfCreditID],0) & "")

     

Gustav_Brock's avatar
Gustav_Brock
Iron Contributor
Jan 20, 2025

Use Nz to return a non-existing value for letterOfCreditID if it is Null:

=DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & Nz([letterOfCreditID],0) & "")

 

Tony2021's avatar
Tony2021
Steel Contributor
Jan 20, 2025

Hi Gustav!  that worked!  I notice you added the & "" at the end and I didnt notice any difference between keeping it and striking it.  It works in both cases though. I have never seen that & "" part though.  Interesting.  I will keep it in my book of secrets.   I thought NZ was the solution but I was using it wrong (=Nz(DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & [letterOfCreditID]),0)...wrong placement of the 0.  I guess sometimes you need to trap at the individual field level, which is what you did.  

.  =DLookUp("Beneficiary","[tblLetterOfCredit]","[LCID]=" & Nz([letterOfCreditID],0) & "")

                                                                                                                                    ^^^

thanks for the tip George!  It makes sense.  have a good day.