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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax error check setting gone?

Status
Not open for further replies.

BallunarCrew

Programmer
Sep 3, 2006
58
US
Am I losing my mind or what? There used to be a setting in the Access Options where we could tell it to not do syntax checks when coding modules and it seems to be gone now. This was so that the programmer could type a partial line of code such as "varName = " and go to another place in the code and it would not stop and throw an error such as Compile Error Expected Expression. Did Microsoft get rid of it and is there some way around it being gone? I have been Googling it and finding lots of pages about how to fix compile errors and syntax errors but I don't want them to come up all the time. I am using Access 365 16.0.13328.20262 32 bit version
 
It is under the VBA IDE's Tools/Options/Editor

Check or uncheck the AutoSyntax option. But think very carefully about whether you really want to do this
 
Thank you so much - I thought I was losing my mind. I am sure I want to do it - I have been coding in Access for MANY year and always have it unchecked. A new laptop has thrown things off a bit.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top