Flickering field (ntext 16)

[smitan]

A field on a form makes the screen flicker when text is entered into it.
The field used to be MEMO, in Access, now is ntext 16 in SqlServer.
There used to be code behind the field (KeyDown) but I took that away TOTALLY.

It unfortunately only happens at my customer, not on my machine.
Any idea?

Greetings
Hans

 

[TelcoBT]

If all fields flickering then I would guess that somewhere you have refresh/requeries cascading - I used to get this on a complex subform I inherited. The bad news is that you may have to put in break points and step through code, I did and even then I also found refreshes in the event properties that meant changing a field didn't need code, it called a macro.

 

[smitan]

Thank you for replying.

Unfortunately, this is not the case.
The flicker is there for EVERY time a key on the keyboard is pressed.

I did put breakpoints on all events for the form and as expected they only stopped the code at a FormAfterUpdate and a FormBeforeUpdate.

But, as the flickers occur per key, and the events per finish-typing, they have no relation to eachother.

Thanks again.
Hans

 

[TelcoBT]

A long shot this one, but does the database compact and repair OK? I ask because I read about a 'DECOMPILE' option that I've used a few times that suggests that not all compiled code is removed in certain circumstances and using it did solve a couple of odd problems for me. I'm certain I read about it on this site, so a search might reveal more information on this.

 

[Rolliee]

It really sounds like a code loop and a slow computer. Go into the design state and change something and then change back so the compiler believes it has to re-compile and then click on debug / compile and see what happens. You probably have a non-fatal warning.

Rollie E