Can I use LIKE in an ordinary IF test

  • Thread starter somanybugssolittletimetofixthem
  • Start date
S

somanybugssolittletimetofixthem

e.g.

Dim strKW as string
strKW = rs("Keywords")
If strKW like " #### " Then
...
End If
 
R

Rick B

Did you try it?

What were the results?


message e.g.

Dim strKW as string
strKW = rs("Keywords")
If strKW like " #### " Then
...
End If
 
M

Marshall Barton

somanybugssolittletimetofixthem said:
e.g.

Dim strKW as string
strKW = rs("Keywords")
If strKW like " #### " Then
...
End If
Click to expand...


Yes you can, but it would have been many times faster to
just try it before posting the question.
 
S

somanybugssolittletimetofixthem

About 50% of the time I solve problems on my own before anyone answers here. But if no-one posted, no-one would learn anything would they?
 

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

Match style 0
VBA Export to PDF 0
MS ACCESS: SEARCH in a split form 0
Word macro that can call cells out of Excel for a find and replace 0
Using "tiles" 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Making a macro only work on certain files 2
Countdown macro - display settings 2

Top