X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Access VBA Editor Autodelete Spaces, Access 2016    
post Jun 19 2017, 11:53 AM

Posts: 21
Joined: 22-May 17

strange question
VBA editor is behaving strangely. It auto deletes spaces, adds second quotes.
I tried qoogling but no luck. and I don't want to mess setting up in VBA.
Go to the top of the page
post Jun 19 2017, 12:04 PM

UtterAccess VIP
Posts: 5,543
Joined: 30-June 11

VBA editor is behaving strangely

This is its normal behavior.

You can't have multiple space in a line of code and it tries to help you by automatically adding the closing quote when you forget. Just have to get used to it.

Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
post Jun 19 2017, 12:30 PM

UtterAccess Editor
Posts: 18,024
Joined: 29-March 05
From: Wisconsin


Do you have a form open running a Timer event by any chance?


(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    22nd January 2018 - 11:30 AM