Predictive Text Not Working

[bscs1963]

This may sound wierd, but I am having a problem entering text in VBA. When I start to type the text, the color of the text turns red as I am typing indicating something is wrong with the code. Normally it only happens after I am done, and it checks the syntax. It is almost like it is checking as I type, and keeps finding issues as I type. For Example:

I want to enter "Set rsTemp = currentdb.openrecordset".

When I begin to type, as soon as I hit the space after "set", the "set" turns red and it automactically backspaces one.

This makes it rather tough to type.

Also, when i would normally get the drop down to select the process such as "Open Recordset", after I hit the first letter, the drop down dissappears.

Any thoughts? Thsi only happens in one db.

 

[BallunarCrew]

I can't say what is going on but having been programming in Access for many years, I have seen a database get corrupted many times. If closing down and reopening or even rebooting does not help, I would create a blank database and import all objects - basically create a new database file. This has helped me many times when Access starts doing things that make no sense. Maybe someone on here has a better solution.

 

[dhookom]

The issue is most likely that you have code running in the On Timer event of an open form. Either close the form or set the Timer Interval to 0.

Duane
Hook'D on Access
MS Access MVP