• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

How to look for double quote character in the InStr() function

These don't work in Access 2007.

Marker = InStr(StartPoint, !PIPnotes, """)
Marker = InStr(StartPoint, !PIPnotes, "chr(34)")

What does?
0
David_W_R
Asked:
David_W_R
  • 2
1 Solution
 
Mike TomlinsonMiddle School Assistant TeacherCommented:
Change:

    Marker = InStr(StartPoint, !PIPnotes, "chr(34)")

To:

    Marker = InStr(StartPoint, !PIPnotes, Chr(34))

0
 
David_W_RAuthor Commented:
I'd like to think I would have thought of that eventually, but you saved me however long that would have taken.
I'm back in  business after a lunchtime nap.
Thanks again.
0
 
Mike TomlinsonMiddle School Assistant TeacherCommented:
Naps make everything better!  =)
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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