UtterAccess.com
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
> Microsoft Visual Basic For Applications 7.1 (editor), Access 2013    
 
   
slowpoke
post Oct 17 2019, 09:57 AM
Post#1



Posts: 26
Joined: 15-April 19



This has been a bother for some time.... I've just been living with it... but hopefully someone here can tell me how to turn this feature off.

Whenever I'm in the editor (Microsoft Visual Basic for Application - editing any sort of events, ie. afterupdate or before update events)

For example:

When i type in: IF (the IF turns RED, when I place a space after the IF, it then automatically removes the space). How do I turn this feature off? My other database doesn't have this feature.

Thanks for your help! Be nice to know what this feature is called.
Go to the top of the page
 
PaulBrand
post Oct 17 2019, 10:18 AM
Post#2



Posts: 1,733
Joined: 4-September 02
From: Oxford UK


Hi,

This isn't a feature it's a bloody nuisance. I see it from time to time, for no reason.

--------------------
Paul
Go to the top of the page
 
arnelgp
post Oct 17 2019, 10:21 AM
Post#3



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


do you have Timer event on your form?

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
GroverParkGeorge
post Oct 17 2019, 10:29 AM
Post#4


UA Admin
Posts: 36,084
Joined: 20-June 02
From: Newcastle, WA


I've only seen it when I move the cursor off the line to another point in the VBA after entering a partial statement.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
slowpoke
post Oct 17 2019, 10:42 AM
Post#5



Posts: 26
Joined: 15-April 19



Actually.... I do have a timer event on the form. The event is to close the Access App if there's no activity in 4 hours. I'm curious as to how the timer event ties into this. Let me know if you know...
Go to the top of the page
 
GroverParkGeorge
post Oct 17 2019, 10:46 AM
Post#6


UA Admin
Posts: 36,084
Joined: 20-June 02
From: Newcastle, WA


See my reply. If the timer moves focus away from the active code line prematurely, it'll error out that way.

Sometimes, it's better to disable timers during other development tasks, for just this reason.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
orange999
post Oct 17 2019, 10:47 AM
Post#7



Posts: 1,988
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


As GPG said, I've only seen this when you start a line of code, then move off that line.
The red line is saying syntax error.
I have not seen the line turn red while still typing, but it will turn red if syntax issue when you go to another line...

--------------------
Good luck with your project!
Go to the top of the page
 
arnelgp
post Oct 17 2019, 10:51 AM
Post#8



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


obiously some Timer event is being triggered on the background.
maybe you have other form's open with timer event also.

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
isladogs
post Oct 17 2019, 02:33 PM
Post#9


UtterAccess VIP
Posts: 1,835
Joined: 4-June 18
From: Somerset, UK


QUOTE
Actually.... I do have a timer event on the form. The event is to close the Access App if there's no activity in 4 hours. I'm curious as to how the timer event ties into this. Let me know if you know...


The timer code means it keeps checking the form if that is in form view causing the cursor to jump about unpredictably.
Either ensure the form is in design view or disable the timer event whilst in the VBE

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st November 2019 - 03:09 PM