Please Help ~

[kelvin H via AccessMonster.com]

If DCount("[Style_Name]", "Styles", "[Style_Name]=' " txtStyle & " ' ) =
0 Then
( return wrong)
(do sth.)
Else
(return true)
(do sth.else)

End if

If the user enter the incomplete word in txtStyle , say "ke " (to be compared
with the field [Style_Name] :"kelvin") ...
What should I do to make it still return true in this case ???
(coz they must be equal (=) in order to return true)

Thanks ~

 

[John Nurick]

Hi Kelvin

Try
"[Style_Name] LIKE '" & txtStyle & "*'"

(that's air code: you may need to sort out the '"&!)

If DCount("[Style_Name]", "Styles", "[Style_Name]=' " txtStyle & " ' ) =
0 Then
( return wrong)
(do sth.)
Else
(return true)
(do sth.else)

End if

If the user enter the incomplete word in txtStyle , say "ke " (to be compared
with the field [Style_Name] :"kelvin") ...
What should I do to make it still return true in this case ???
(coz they must be equal (=) in order to return true)

Thanks ~