Connecting Tech Pros Worldwide Help | Site Map

Bring to front - by VBA code

  #1  
Old September 3rd, 2006, 01:25 PM
muymalestado
Guest
 
Posts: n/a
In A2000 is it certain that one cannot perfoem 'Bring to front' using
code.

Is is also the case that 'Visible = True or =False' is different and
separate from a control's zorder and thus that if two or more controls
are positioned directly above one another simply setting 'Visible =
True' will not bring that control up to be visible and clickable.

Thanks

  #2  
Old September 3rd, 2006, 01:35 PM
Allen Browne
Guest
 
Posts: n/a

re: Bring to front - by VBA code


Would it be satisfactory to SetFocus to the control?

In code:
Me.[Text0].SetFocus
or in a macro, use GotoControl.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"muymalestado" <pfo@ecosse.netwrote in message
news:1157286847.875008.241860@b28g2000cwb.googlegr oups.com...
Quote:
In A2000 is it certain that one cannot perfoem 'Bring to front' using
code.
>
Is is also the case that 'Visible = True or =False' is different and
separate from a control's zorder and thus that if two or more controls
are positioned directly above one another simply setting 'Visible =
True' will not bring that control up to be visible and clickable.
>
Thanks

  #3  
Old September 4th, 2006, 07:15 AM
Terry Kreft
Guest
 
Posts: n/a

re: Bring to front - by VBA code


You set the other control to be .Visible = False

--

Terry Kreft


"muymalestado" <pfo@ecosse.netwrote in message
news:1157286847.875008.241860@b28g2000cwb.googlegr oups.com...
Quote:
In A2000 is it certain that one cannot perfoem 'Bring to front' using
code.
>
Is is also the case that 'Visible = True or =False' is different and
separate from a control's zorder and thus that if two or more controls
are positioned directly above one another simply setting 'Visible =
True' will not bring that control up to be visible and clickable.
>
Thanks
>


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Noob question: Excel VBA entering information on java forms orangekeeper answers 0 October 19th, 2007 04:57 PM
Unable to see form while stepping code (A2003) Lyn answers 7 June 4th, 2007 02:45 AM
Database window AWOL Denburt answers 6 March 19th, 2007 10:06 PM
How to make Command Buttons 'pretty'??? Susan Bricker answers 8 November 13th, 2005 12:49 AM
launching applications with javascript David answers 1 July 23rd, 2005 04:26 PM