G Guest Nov 14, 2003 #1 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???
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 Nov 14, 2003 #2 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???
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???
