how to remove error in my access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • adorico
    New Member
    • Nov 2017
    • 1

    how to remove error in my access

    how to remove error in my access

    like =SpellNumber([Text51]) it`s showing Error when no data
    Last edited by NeoPa; Nov 12 '17, 12:01 AM.
  • PhilOfWalton
    Recognized Expert Top Contributor
    • Mar 2016
    • 1430

    #2
    Like is a reserved word and should not be used, so let's call it MyLike instead.

    I Presume SpellNumber is a function yo have designed

    Try
    Code:
        If Nz(Text51) > "" Then
            MyLike = SpellNumber([Text51]
        Else
            MyLike = "No Number"
        End If
    Phil

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32645

      #3
      It doesn't matter what language you're writing your question in - that is always far too little information to post when asking a question. Also, never post a question with code you've typed in on the post. Copy & Paste it to avoid stupid errors that are not even what you're struggling with. This wastes everybody's time and is quite inappropriate behaviour when using any forum.

      Comment

      Working...