stLinkCriteria and wildcards?

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

This stLinkCriteria works ok, that is, it returnes the exakt matches from
the "txt_bladdra_per_fritext" textbox

stLinkCriteria = "forklaring =
[Forms]![startform]![txt_bladdra_per_fritext]"

However, this of course returns only exact matches. How do I make this so
that it finds matches that is similar to the parameter I wrote in the
"txt_bladdra_per_fritext" textbox? No matter if the word I'm looking for is
in the middle of a sentence or starts with a capital letter and I write the
word in small letters and so on?
I have fiddled with wildcards like &"*", used the "Like" word but without
getting this to work.

Jen.
 
Jen,

See if this works....

stLinkCriteria = "forklaring Like '*" &
[Forms]![startform]![txt_bladdra_per_fritext] & "*'"

Gary Miller
 
Works perfectly. Thank you so much Gary!

Jen.

Gary Miller said:
Jen,

See if this works....

stLinkCriteria = "forklaring Like '*" &
[Forms]![startform]![txt_bladdra_per_fritext] & "*'"

Gary Miller


Jen said:
This stLinkCriteria works ok, that is, it returnes the exakt matches from
the "txt_bladdra_per_fritext" textbox

stLinkCriteria = "forklaring =
[Forms]![startform]![txt_bladdra_per_fritext]"

However, this of course returns only exact matches. How do I make this so
that it finds matches that is similar to the parameter I wrote in the
"txt_bladdra_per_fritext" textbox? No matter if the word I'm looking for is
in the middle of a sentence or starts with a capital letter and I write the
word in small letters and so on?
I have fiddled with wildcards like &"*", used the "Like" word but without
getting this to work.

Jen.
Click to expand...
Click to expand...
 
Back
Top