Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disable Autocorrect for One Line

Status
Not open for further replies.

mekohler

Technical User
May 4, 2007
64
CA
Hi in Access I've created a module where I refer to a local server as Sql\HINTN, but autocorrect keeps changing the line to SQL \ HINTN. How do I stop the VBA editor from making this change? The line of code should be "SERVER=" & SQl\HINTN & ";" & _ but keeps getting changed to "SERVER=" & SQL \ HINTN & ";" & _
Thanks,
Michael Kohler
 
Hi,

I'm guessing that SQL and HINTN as text vale use and not variables. If so...
[tt]
"SERVER=" & "SQL\HINTN" & ";" & _
[/tt]

Or simply...
[tt]
"SERVER=SQL\HINTN;" & _
[/tt]

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top