IF textbox on form has this value, with wildcards???

[redbull]

I have a form that has multiple textboxes. I am creating an IF statement, basically if value = this then that.. Here is the problem I am having, sometimes the textbox has MORE then one piece of data in it.



---This works just fine---
--Form txtroles.value = First Base--

--This code works in this case---
If Forms!frmmainnew!.txtRoles.value = "First Base" Then
do this
end if
----------------------------------
---This does not work at all---
--Form txtroles.value = First Base, Center Feild--

--This code does not work in this case---
If Forms!frmmainnew!.txtRoles.value = "First Base" Then
do this
end if
----------------------------------


Can I wrap wild cards around "First Base" so it just looks at the whole text?? Does VBA even support wildcards??

[redbull]

I was able to do what I needed... THanks for listening lol

If Forms!frmmainnew!.txtRoles LIKE "*First Base*" Then

Anyone see any issues with it??

[Missinglinq]

Only issue I see is that you're violating the 'Atomic Rule' of relational databases; you're storing multiple pieces of data in a single Field.

Linq ;0)>

[Perceptus]

I was able to do what I needed... THanks for listening lol

If Forms!frmmainnew!.txtRoles LIKE "*First Base*" Then

Anyone see any issues with it??

If [Forms]![frmmainnew].txtRoles LIKE "*First Base*" Then

hope this helps.