title: Access Form Bring Text Box in Front of Listbox?
body: <p>This application is Access 2010, with a SQL backend.</p>
  
  <p>I have a form, which has a tab control, with 2 pages.  1 page has 1 listbox and the other has 2 listboxes.  I use some code, on change of the tab control, to determine the active page, and set the listbox(es) row source(s) for the one(s) on the active page, and clear it out on the inactive page.  This takes a sec and the listboxes look yucky while this is happening.</p>
  
  <p>To prevent the user from seeing this, I made a text box, with a colored background and the control source ="Please Wait One Moment..."
  with like 48 font.  On load of the form, this textbox is visible = false.  On click of the tab control, the text box is to be made visible, and it is big enough to cover then entire tab control. It does cover the tab control, but I can still see the listboxes through the text box.  The text box has a back color and is not transparent. I tried right-clicking the listboxes in design view and choosing Position - Send to Back, and right-clicking the textbox and choosing Position - Send to Front.</p>
  
  <p>This doesn't seem to work.  Is anyone familiar with this issue? Figuring someone has tried a trick like this.</p>
  
  <p>The meat of my code is all functioning properly, for this on change of the tab control.  I have this code at the beginning:</p>
  
  <pre><code>DoCmd.Hourglass True
  Me.txtPleaseWait.Visible = True
  Me.Repaint
  Application.Echo False
  Debug.Print Me.txtPleaseWait.Visible
  </code></pre>
  
  <p>and this at the end:</p>
  
  <pre><code>Application.Echo True               
  Me.txtPleaseWait.Visible = False    
  Me.Repaint                          
  Debug.Print Me.txtPleaseWait.Visible
  DoCmd.Hourglass False               
  Debug.Print "got to end of resting form state"
  </code></pre>
  
  <p>Does that make sense?</p>
  
  <p>Should I handle this differently?</p>
  
  <p>Thank you.</p>
  
  <h2>Edit</h2>
  
  <p>I found that listboxes have a higher zorder than textboxes, so I changed my textbox to a listbox.  I still see the listboxes from the tab control, through the listbox I'm using to cover them up.</p>
  
  <p>Is there a control that would better cover these and could have this "intermission" type message show, while the listboxes are being set and unset?</p>