Search function

J

John Doherty

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???
 
J

Jack

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???
 
Top