Module-Using "Wildcards"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Public Sub in Module 10
Using Modules 1
Reference Std Module in Select Query 4
ECHO OFF applying to MULTIPLE Macros or MODULES! 1
Module Help 5
undefined function 'xxx' in expression - user function 2
Common (data)module for all windows (MDI) 1
DateValue 5

Back
Top