Solved change any code color to red

[Safari]

when i am trying to write vba code its automatically change font color to red and not accepted to complete the code also refuse to get any text property like :
me. not open the properties combo box .

how can i solve it

 

[pbaldy]

Do you have a form open with a timer event running behind it?

 

[Safari]

Do you have a form open with a timer event running behind it?

Yes i have its the main form i made digital form on it .

What can I do?

 

[pbaldy]

That code causes this issue. Either close that form, put it in design view, or temporarily take out the timer event code while you're developing.

 

[Safari]

Ok i will try it

 

[pbaldy]

That is "the usual suspect" so I think you'll be fine. Basically you just have to stop that timer in one way or another while you're developing.

 

[Mike Krailo]

@pbaldy I'm not familiar with this particular problem, is this something that can be demonstrated? It would be nice to see an example of this issue.

 

[Safari]

Thanks
It's Working

 

[Mike Krailo]

Timers interfere with code.

But how exactly? Is there a simple demo of this problem somewhere? I have lot's of code that uses timers in various projects and have never seen this before. Maybe because when I work on the code, all the forms are in design view, I don't really understand what steps to take to duplicate the problem.

 

[Mike Krailo]

Open a form with a timer so it is running and work on some other form. Frequently the timers are in the menu or login form so you can't actually test with them in design view so you have to have a way to just turn off the timers.

Thank you Pat, that was very simple to duplicate and now I see exactly how to avoid that in the future.

 

[Mike Krailo]

If you want my code for turning off the timers, I'll dig it out.

That's not necessary, but I appreciate the offer. I just finished updating my notes on this issue and played around with duplicating the problem. I think I did see this in the past but didn't understand what was going on at the time. Now I know.

 

[pbaldy]

Thanks
It's Working

Happy to help!