the search function

[mewfin]

any way to set the searchfuntion to only search for part of the word as standard?
or is it any other way to make a search function where u can write like 133 and get all the numbers starting on it.

 

[maxmangion]

you can use the wildcards ? (for 1 character) and * (for a series of characters). Also search this forum for the "Like" function.

 

[mewfin]

get nothing when searching for Like.
btw u got that i mean i wanna write whatever in a textfield and it finds all records with that part of a word/number in it?
not only 133.

 

[maxmangion]

try :

Like "*" & [YourFieldName] & "*"