Compare two Strings in Access using VBA

[Weiler]

I'm a relative newbie to VBA and I am STUMPED.

I'm trying to use vba in MS Access to compare two fields to see if the
second string can be found somewhere in the first.

For example, I would like the statement to return true if:

StrOne = 00035A,00035B,2000,00103A
StrTwo = 00035B

Can anyone help?

Thanks in advance,

J

[Jeff Pritchard]

Try the InStr function.

Jeff

"Weiler" <we********@hotmail.com> wrote in message
news:78**************************@posting.google.c om...

I'm a relative newbie to VBA and I am STUMPED.

I'm trying to use vba in MS Access to compare two fields to see if the
second string can be found somewhere in the first.

For example, I would like the statement to return true if:

StrOne = 00035A,00035B,2000,00103A
StrTwo = 00035B

Can anyone help?

Thanks in advance,

J

[Tim Marshall]

Weiler wrote:

For example, I would like the statement to return true if:

StrOne = 00035A,00035B,2000,00103A
StrTwo = 00035B

Look up help on the instr function. For the above,

InStr(1,strOne, strTwo) = 8

If it's 0, strTwo isn't in there.

--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Want some?" - Ditto

[CDB]

Look up Instr() function in VBA Help.

Or, reconsider the data design - such repeating values should not be stored
in one field in a table. They should be stored in eg 4 records. Then VBA is
not needed - SQL will do the job.

Clive
"Weiler" <we********@hotmail.com> wrote in message
news:78**************************@posting.google.c om...

I'm a relative newbie to VBA and I am STUMPED.

I'm trying to use vba in MS Access to compare two fields to see if the
second string can be found somewhere in the first.

For example, I would like the statement to return true if:

StrOne = 00035A,00035B,2000,00103A
StrTwo = 00035B

Can anyone help?

Thanks in advance,

J