Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to compare strings 1

Status
Not open for further replies.

srast

MIS
Joined
Nov 11, 2002
Messages
42
Location
US
Hello all.
I want to compare the value of a string expression entered by a user, with a second string, to test for equality. What function could I use to accomplish this? I looked through Access's help section with no luck.
Any assistance would be appreciated.
Thanks
Steve
 
Access 2000 and above: look up InStr in Access Help. It takes the form:

Code:
Instr([Start], [String1], [String2], [Compare As VBCompareMethod = vbBinaryCompare])
[pc2]
 
Thanks. I'll check it out.
Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top