Search function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a text control on a form I enter =Search("B","ABCD",1) expecting the answer 2 but get #Name? error. Similarly if the source is an existing Table etc Whats going on???
 
There is no built-in "Search" function. What you want to
use is =InStr("ABCD","B",1).
-----Original Message-----
In a text control on a form I enter =Search("B","ABCD",1)
Click to expand...
expecting the answer 2 but get #Name? error. Similarly if
the source is an existing Table etc Whats going on???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Create option group without using wizard? 2
Preventing duplicate record entries where two fields are involved 13
code or Query 2
How do I fix #Name? error in IIF form display expression? 4
unique count 1
What is Automation ID? 7
Search form via filter 5
Tables/Queries Exists() Function 2

Back
Top