423,336 Members | 1,196 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,336 IT Pros & Developers. It's quick & easy.

how to remove error in my access

P: 1
how to remove error in my access

like =SpellNumber([Text51]) it`s showing Error when no data
Nov 11 '17 #1
Share this Question
Share on Google+
2 Replies


PhilOfWalton
Expert 100+
P: 1,296
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
Expand|Select|Wrap|Line Numbers
  1.     If Nz(Text51) > "" Then
  2.         MyLike = SpellNumber([Text51]
  3.     Else
  4.         MyLike = "No Number"
  5.     End If
  6.  
Phil
Nov 11 '17 #2

NeoPa
Expert Mod 15k+
P: 31,004
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.
Nov 12 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.