inStr

[Guest]

Hi,
what's the syntax of InStr function when I'm looking a sign ';' in a string.
I'm getting an error all the time.
thanx
alek_mil

 

[Brendan Reynolds]

InStr(1,"some;text",";")

.... or ...

InStr(1, SomeFieldOrVariableName, ";")

.... or ...

InStr(1, SomeFieldOrVariableName, SomeOtherFieldOrVariableName)

In other words, quotes around literal string values, but not around field or
variable names. Put square brackets around field names if they contain
spaces, or if you're using the function in a query or expression and Access
insists on 'helpfully' inserting quotes around the field name for you.

The first 'Start' argument (1 in the examples above) is optional but is
required in some circumstances. As I'm too lazy to try to remember when it
is required and when it isn't, I just always include it.

 

[Graham R Seach]

Alek,

Have you tried looking it up in Help??
Syntax

InStr([start, ]string1, string2[, compare])

The InStr function syntax has these arguments:

Part Description
start Optional. Numeric expression that sets the starting position for
each search. If omitted, search begins at the first character position. If
start contains Null, an error occurs. The start argument is required if
compare is specified.
string1 Required. String expression being searched.
string2 Required. String expression sought.
compare Optional. Specifies the type of string comparison. If compare
is Null, an error occurs. If compare is omitted, the Option Compare setting
determines the type of comparison. Specify a valid LCID (LocaleID) to use
locale-specific rules in the comparison.


There's also InstrRev(), which you might look up.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia