The VB editor is behaving strangly.

[Guest]

I have been working with vb code window for 3 months. It has just started to
act strangly. I must have turned some option On without knowing it.
It Corrects as I type with strage results. I mght type Variable=false and
expect it to add the spaces and Capitals when I leave the line. Now as soon
as I type "f" it expands the spaces and I find I'm typing to the left of the
"f".
ALso I loose the popup properties and controls list within a second and I
rely on this. I have tried switching off options in Options but without
result.
Could someone please help as this is "stifly my style".
Thanks in Advance.

 

[Guest]

Hi.

I have been working with vb code window for 3 months.
It has just started to act strangly.

Do you have a form open with a timer? If so, every time the timer event
fires, the VB Editor will lose focus and mess up what you're trying to do
when it regains the focus. If this is the case, then close the form while
you're editing the VBA code or just set the timer interval to 0.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Guest]

Perfect
Thanks a lot

Hi.


Do you have a form open with a timer? If so, every time the timer event
fires, the VB Editor will lose focus and mess up what you're trying to do
when it regains the focus. If this is the case, then close the form while
you're editing the VBA code or just set the timer interval to 0.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

['69 Camaro]

You're welcome. Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.