Filtering for Ends With

[gg80]

Probably simple, but driving me nuts. I want to filter a list for entries that end with certain characters. If I put the characters in the code, like this:



Form.Filter = "[Item] Like '" & "*" & "M28'"
it works fine.

How do I refer to a control instead having to write the characters in the code?. I have no problems with "begins with" or "Contains", but can't seem to find the right combo of quotation marks and apostrophes to make "ends with" work.

An aside: Is there some site that explains the logic of using quotation marks, and apostrophes and parentheses in vba filter expressions?. I just copy them, but somehow miss the logic associated with them (as you can tell from my question.)

Any help much appreciated.

[orange]

You could try this (untested)

Form.Filter = "[Item] Like '*M28'"

[gg80]

My question was how do I substitute "M28" with a me.controlName. If I type the desired end in quotation marks in the code expression, no problem. I want to be able to enter desired " ends with" in a control on a form, then have the code use that value as a filter.

You could try this (untested)


Form.Filter = "[Item] Like '*M28'"

[orange]

How about (still untested)

Form.Filter = "[Item] Like " & "'*" & Me![Text0] & "'"

[gg80]

Must be something wrong with my Access. I tried above and acted like Contains rather than Ends With. I will run a repair and try code as you show it. Thanks for following up. If you get a chance to test, would appreciate it much. I am going nuts.

[gg80]

I tested this on another computer with A2003. It also acts like a "contains" expression rather than an "Ends With". Is this some problem with Access? Any other ideas?

Must be something wrong with my Access. I tried above and acted like Contains rather than Ends With. I will run a repair and try code as you show it. Thanks for following up. If you get a chance to test, would appreciate it much. I am going nuts.

[June7]

The syntax for the LIKE and wildcard expression provided by orange is correct. Should return only those records where the value ends with M28.

However, I am somewhat surprised by the success with Form prefix. Where is this code?

Could eliminate one concatentation although the results should be same. And I use dot to reference controls.

Form.Filter = "[Item] Like '*" & Me.Text0 & "'"

[gg80]

Just to be sure, I created a new form sourced from another table and your last expression works fine. Must be some bug or corruption.

Thanks so much- Really appreciate the help. Without this site I would give up.