Rubberduck version information
Version 2.5.0.5524
OS: Microsoft Windows NT 10.0.14393.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.12527.20880
Host Executable: MSACCESS.EXE

Description
Auto completion doesn't seem to work sanely when in a middle of string. This becomes quite annoying when constructing long strings that needs variable interpolated.

To Reproduce
Given the code:

foo = "abc| def" 

I want to modify this and insert a variable, so I type " & bar & , leaving me at this:

foo = "abc" & bar & | def" 

I then type " and the autocomplete kicks in:

foo = "abc" & bar &"|" def" 

This is now invalid line and I have to delete the ", add a space between the & and the remaining " to get me this valid line:

foo = "abc" & bar & "def" 

Expected behavior
I think the simplest fix is to prevent autocompletion when interpolating in middle of a string, especially if the line contains odd number of quoting characters.