Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a particular word so that it doesn't get in the way.
For example say I had the following query
SELECT Foo, Foo2 FROM SomeTable
As I type
Foo and then hit space-bar SQL Server Management Studio's auto-complete kicks in and completes