Module-Using "Wildcards"

S

spacecadet

I would like to look up vaules in a field and if they match a criteria to
replace the value with an "X". This is written in a module.

Example:

If [ScreenLable]="Main*" (That is the criteria you would use in a query. I
want it to find all Strings that start with the word Main. However this does
not work in a Module. So what will work in a Module?) Then Public Function
Name()="X"

Can anyone help?

Sarah
 
S

Steve Schapel

Sarah,

If [ScreenLable] Like "Main*" Then

By the way, this would be the same in a query, [ScreenLable]="Main*"
would not work there as required either.
 
Top