I have this:
ModelRangeFound: InStr([mODEL RANGE],[forms]![Form1].[word].[value])>0
It fails as it picks up the search word anywhere.
I was thinking of using regex to do the search term but how do I tell it to use the found word if its the first or second word only?
"RG125 bike year a6" fails as it finds as a6 at end
"A6 quattro s line" This is valid
How do I get regex to find the search string but only return true if the search word is at the beginning of the sentence?
I dont know how to make that regex pattern