Bring To Front & Send Back Properties using VBA

[gstylianou]

Good Evening



In the database I am attaching there is the form Form1 on which there are several fields with hours. The request is to be able to define the Properties Bring To Front & Send Back via VBA when and if I click on the Text0 field.

I am providing an example of the request and I will appreciate your help.

Thanks in advance

[Welshgasman]

https://stackoverflow.com/questions/...r-send-to-back

From https://www.google.com/search?q=brin...hrome&ie=UTF-8

[davegri]

My understanding of Z-axis movement (front-to-back or back-to-front) is only observable for superimposed (layered) objects. I don't see that in your DB, so I have no suggestions, or means to test.
Perhaps you could explain what purpose the movement is supposed to accomplish? What do you want to see as the result of the movement?

[Micron]

I don't see any layered objects either, and if this is about z order for forms, IIRC Access does not support that for forms. If it is about controls, then I think this is neither a property or a method for any control. Methinks it is only doable via either application.runcommand or docmd.runcommand - in other words programmatically running ribbon commands. Even then, there is a send and a sendtoback command but there doesn't seem to be a sendtofront command. If one could get that to work, I imagine the only thing you can do is move things back in the layers. That could mean a whole bunch of sending back until the desired object ends up in the front. Probably not an issue with two controls, but certainly could be with several layers.

[pbaldy]

The last time you asked this (that I know of) it quickly evolved away from back and front:

https://www.access-programmers.co.uk.../#post-1910087

[Welshgasman]

The last time you asked this (that I know of) it quickly evolved away from back and front:

https://www.access-programmers.co.uk.../#post-1910087

I *thought* the username and question was familiar.
One for the my IL methinks.

Nice catch.

[Micron]

What I like about AccessWorldForums is how easy it is to put cross posters (who don't provide links to other sites) on your ignore list.

[pbaldy]

I apparently goofed and posted a link to a post instead of the thread itself. Post 11 is where the requirements got refined/changed.

[Welshgasman]

What I like about AccessForums.net is how easy it is to put cross posters (who don't provide links to other sites) on your ignore list.

Easier over on AWF :-)

[Welshgasman]

Anywhere in the thread is good enough.

[Micron]

Easier over on AWF :-)

Yup. I edited; thanks.