View Single Post
  #4  
Old April 16th, 2008, 05:53 PM posted to microsoft.public.access.forms
George Nicholson
external usenet poster
 
Posts: 791
Default How do I "Bring to Front" in VBA?

These aren't object properties per se, they are instructions that the user
interface provides (which evidently set some other GraphicLayer property
that is not exposed).
Docmd.RunCommand acCmdBringToFront
Docmd.RunCommand acCmdSendToBack

However, afaik they will only work while the form is in Design view.
Invoking them while in Form View generates a "..not available now.."
message, so manipulating Visible is the more dynamic solution.

--
HTH,
George


"M Skabialka" wrote in message
...
I have a form which is divided into sections where each background is a
box. This makes it easier to manage the info for the user. However there
are some functions I have placed on one of the boxed areas that I don't
want all users to see. I am looking for a setting that will cause this box
to use the "Bring to Font" property, rather than make all of the controls
on it not visible. When I look at the proprties in Intellisense, Bring To
Front and Send to Back are not there. How do I do this?
Mich