How do I compare strings? 1

[cindyray]

I used a maskeditbox to ensure the entries made to an Access database were made correctly, but now I need to do run a labels based on the date. Is there an easy way to handle this?

 

[Kaushik1975]

You can use StrComp function to compare 2 strings

 

[cindyray]

Is StrComp able to find multiple matches and ones that are greater than the date I'm searching?

 

[IonelBurtan]

You can use also InStr(or InStrRev) to find the matches wanted, another way would be to use regular expresion from the vbscript runtime library(the regexp object).

It has a rather strange sintax but is the fastest and versatile of all.

Anyway if you will spend some time learning Regular Exppresion you will find for it many usages.

Hope this helps s-)

Blessed is he who in the name of justice and good will, shepards the week through the valley of darkness...

http://www20.brinkster.com/ionelb

 

[cindyray]

I ended up doing a type conversion from string to date during my search and this worked much better than the StrComp and InStr...mainly because it ended up being so much simpler and easier to code. Thanks for the help.

Cindy