Refresh unbound textbox
in [General]
|
From: alex on 27 Apr 2010 15:52 On Apr 27, 3:28 pm, Daryl S <Dar...(a)discussions.microsoft.com> wrote: > Alex - > > Add a Me.Repaint in the code after each textbox update. > > -- > Daryl S > > > > "alex" wrote: > > Refresh unbound textbox > > > Hello, > > > Using Access 03 > > > I have quite a bit of VBA code that runs a variety of queries. > > Between all of the SQL code, I display information to the user in an > > unbound textbox on the form. Something like this: > > > > Sub RunQueries() > > Me.unboundTextBox = About to run queries > > > Me.unboundTextBox = Running Query A > > Docmd.runsql(queryA) > > > Me.unboundTexBox = Running Query B > > Docmd.runsql(queryB) > > > > > > Me.unbountTextBox = Running Query Z > > Docmd.runsql(queryZ) > > > Me.unboundTextBox = Finished queries > > End sub > > > > > The problem is that (on some occasions) the queries will run without > > the text being displayed; i.e., the textbox will display About to run > > queries and then will display Finished queries. I thought the > > problem was that the queries ran so fast, I just couldnt see the > > textbox change, but this happens even when it takes a few moments for > > the queries to finish. E.g., I can see the queries running in the > > lower left-hand status bar, but the text will not change. > > > Its almost like I need to put in a break (like a msgbox) to get the > > textbox to refreshwhich works strangely enough? Or possibly to set > > the focus back to form/textbox? > > > Any thoughts? > > alex > > .- Hide quoted text - > > - Show quoted text - Wow, I've never got this much help this fast! I just did some preliminary testing and it looks like me.repaint works. I'll post back if that doesn't hold true. I appreciate the help as always. alex |