Solved: Search only Display Text in Hyperlink

[Adonaioc]

If Not IsNull(Me.txtFilterSlot1) Then
strWhere = strWhere & "([tblSlot1_ItemLink] Like ""*" & Me.txtFilterSlot1 & "*"") AND "
End If


This is searching a hyperlink field and the search pulls from the hyperlink address as well is there a way to tell it to search only the display text or only up to the first # sign?

[CreganTur]

Take a look at the HyperlinkPart method- it will allow you to select certain parts of the hyperlink. Read up on it in Access Help:thumb

[Adonaioc]

Worked Wonderfully Thanks