Priority of Controls placed over each other

Posted on 2006-06-14
Medium Priority
Last Modified: 2010-04-07
If I first place a Textbox on a form and then place a Datagrid on the form the Datagrid has priority i.e. if I move the Datagrid over the Textbox the Datagrid hides the Textbox. However if I place the Datagrid on the form first and then place the Textbox on the form and again move the Datagrid over the Textbox - the Textbox shows through the Datagrid i.e. the Datagrid appears transparent. Is there a property that determines this behaviour? I want the Datagrid to hide the underlying Textbox. I can solve this in one of 2 ways: 1) I can place the Datagrid on the form last or 2) I can programatically make the underlying Textbox invisible. However I am curious to know what determines this behaviour.
Question by:cdv
LVL 86

Assisted Solution

by:Mike Tomlinson
Mike Tomlinson earned 500 total points
ID: 16904294
You can make the DataGrid come to the front by using the ZOrder method.

Something like...

    Private Sub Form_Load()
        DBGrid1.ZOrder 0
    End Sub

Accepted Solution

Extortioner15 earned 500 total points
ID: 16904314
right-click the item you want behind the other object, and choose "Send to Back". That should do the trick nomather the order you put it in!

Author Comment

ID: 16906711
Thanks. Both answers have answered the question.

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question