Hello Friends!
Let's say I have a line of code like this below:
I am having a difficult time highlighting part of this SQL query - somehow VBA editor is selecting the entire line for me.
e.g I want to select variable10 to copy, it's going to select the entire line of code........I have to be really slow when I select and often it takes couple attempts.
I think this only happens when I try to select part of the codes in a SQL query...because I had no issues selecting couple words from the code below:
Is there an option to disable this auto-selecting? A colleague has suggested to break the codes to couple lines - I believe this will solve the problem but I wanted to check to see if there's any better solutions.
Thanks!
Allan
Let's say I have a line of code like this below:
Set rs1 = New ADODB.Recordset rs1.Open "SELECT * FROM WHERE [Column1] = " & [Variable1] & " AND [Column2]= '" & [Variable2] & "' AND ................[Column10] = '" & [VARIABLE10].Value &", CurrentProject.Connection, adOpenStatic, adLockOptimistic, adCmdText |
I am having a difficult time highlighting part of this SQL query - somehow VBA editor is selecting the entire line for me.
e.g I want to select variable10 to copy, it's going to select the entire line of code........I have to be really slow when I select and often it takes couple attempts.
I think this only happens when I try to select part of the codes in a SQL query...because I had no issues selecting couple words from the code below:
string1 = "hello i think this can be a long code so i want to see if this issue is only happening when it's a sql query. adding couple more words to make this long enough" |
Is there an option to disable this auto-selecting? A colleague has suggested to break the codes to couple lines - I believe this will solve the problem but I wanted to check to see if there's any better solutions.
Thanks!
Allan