VBA editor auto changes "." to "'#" as you type ... not just after pressing <enter>?

OK, while adding code in the VBE, just start a new sub like:

Function RRP(MLP)
If MLP < 0.1 Then

or

Function RRP(MLP)
If MLP = "abc" Then

by the time you try and type the "1" or the "a" the editor has changed the "," to a "#" or the single " has been made a double ", this is the behaviour that would normally happen when you press <enter> and the VBE reformats and adds spaces either side a "=" sign etc.
In fact if you type "A=1" quickly the VBE reformats to "A = 1" and leaves the cursor in position 4 just after the "=".

This happens in real-time, not when you press enter, while on other machines/access VBE these happen only after you press <enter> or scroll to a new line.

It is not related to any specific code or statement, not about running the code this is just about code entry within the VBE.

Also I'm not sure how to put a worksheeet in design mode, unless you mean being in the VBE, which I am?

My other machines all behave as expected even with the same file, it is only 1 machine doing this "real-time" reformating, and the Access VBE is not affected it is also working as it should

Thanks

Now at the office, so laptop has had a reboot and problem gone, but romperstomper is correct, the Design Mode button on the developer Tab of the Excel ribbon (never used that button before) does toggle this ... (as well as the icon on the VBE menu).
So thanks, next time (after 15years without an issue, not sure there will be a next time!) I'll be able to fix it in a click!
Not sure why I've never come acros this before, what else does it do/control?
Should I be using it more often?
thanks again

well much appreciated, otherwise I'd have rebooted and never got to the bottom of it!
I'll try and browse some of the other posts and even contribute a little if time permits, as this looks like a fairly active board, so where I can help I'll try!

BTW do you know of any really good MsAccess forums, there are lots out there but a recommendation is always best, as "cross posting" is always considered poor form, it's hard to know which are actually any good.

thanks