Form-Screen blinking during update text-box

[Evgueni Zoldin]

Hi, ALL!

During the long process I would like to update report text in multiline-text
box to show to customer the status of performing. When I change the content
of the textbox by append new report-text at the end, I try to scroll to the
end of tex by the following:

Me.txtResult.SelStart = Len(Me.txtResult.Value)
Me.txtResult.SelLength = 0

(focus is already set into the text-box). If the updates occur enough often
then screen (namely the form) is blinking absolutely indigestibly. Will be
appriciable for any advice.

Thanks

 

[StCyrM]

Hi

Try setting Echo to False. This will freeze the screen while the updates are
done.

Maurice

 

[Richard]

Hi

How do you set the echo to false?

Thanks in advance
Richard

 

[StCyrM]

Hi ...the command line to set the Echo is as follows:

DoCmd.Echo False, ""

 

[Richard]

Hello

I tried it but the whole screen turns blank. Do you put in after the code or
before?

Thanks again

Richard

 

[StCyrM]

Hi Richard

You would place the code before you start your update:

DoCmd.Echo False, ""

...and once you are done the update(s), turn Echo back on:

DoCmd.Echo True, ""

Maurice