By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 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

Expert 100+
P: 1,430
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

Expand|Select|Wrap|Line Numbers
  1.     If Nz(Text51) > "" Then
  2.         MyLike = SpellNumber([Text51]
  3.     Else
  4.         MyLike = "No Number"
  5.     End If
Nov 11 '17 #2

Expert Mod 15k+
P: 31,398
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.