Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

Hash sign in me.filter expresion

Microsoft Access 2013

Hi.

Following code fails because of the  # character (hash sign).
Me.Filter = "[Template Name] like '*template #2*'"
Me.FilterOn = True

Open in new window


How do I deal with this?
0
peispud
Asked:
peispud
1 Solution
 
Rgonzo1971Commented:
Hi,

have you tried

Me.Filter = "[Template Name] like '*template [#]2*'"

https://msdn.microsoft.com/en-us/library/office/gg251796(v=office.15).aspx

Regards
0
 
peispudAuthor Commented:
Me.Filter = "[Template Name] like '*template [#]2*'"
Me.FilterOn = True

Thanks.

Found the solution there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now