TimerInterval unbound textbox

  • Thread starter Thread starter fysh1
  • Start date Start date
F

fysh1

I attempt to work at my problems until I start running in
circles. Well here is on that I posted a couple days ago,
but didn't really get any help.

I have a timerinterval set for a form the requeries the
information every 2 minutes. This works fine and shows
new records, but the unbound textboxes flash with the same
info every time the time event occurs. Is there a way to
stop the flash on the text boxes when the timer interval
happens? Say for instance I have a concatenate box and a
count box, when the timer interval happens the information
disappears and reappears. If so how do I go about doing
it? These are the only 2 textboxes that this happens to
and it doesn't look right on the continuous form. These
boxes are unbound to the underlying query of the form.
Someone mentioned ECHO method, but I don't see how that
applies. Can someone assist me on this?

Thanks in advance,
 
If you look at the help screens for Echo it does actually do what you want.
This is what it says:

"If you are running Visual Basic code that makes a number of changes to
objects displayed on the screen, your code may work faster if you turn off
screen repainting until the procedure has finished running. You may also
want to turn repainting off if your code makes changes that the user
shouldn't or doesn't need to see."

Here is an example

On Timer Event
DoCmd.Echo False, "Doing the concatenations"
'Do whatever you want
DoCmd.Echo True, "Finished"
 
Back
Top