Hide Properties

[Dominic Vella]

I'm developing using MS-Access 2000.

When I open a form in 'Form' view, how can I determine if the properties box
is open, and then how do I hide the properties box?

Thanks in advance.


Dominic

 

[Tom van Stiphout]

On Mon, 25 Aug 2008 09:13:27 +1000, "Dominic Vella"

If you deploy your application per best practices and turn it into an
MDE, you won't have this problem.

-Tom.
Microsoft Access MVP

 

[Dominic Vella]

Thanks, that's excellent.

Dom

Actually, I just tried it and using the Windows apis doesn't require much
coding. Put these 3 declarations at the top of the module:

Private Declare Function _
FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long

Private Declare Function _
SendMsg Lib "user32" Alias "SendMessageA" _
(ByVal hwnd As Long, ByVal wMsg As Long, _
ByVal wParam As Long, ByVal lParam As Long) As Long

Private Const WM_CLOSE = &H10


Now in a procedure where you want to close the properties window if it's
open,
paste this line of code:

SendMsg FindWindow("OArgDlg", vbNullString), WM_CLOSE, 0, 0


Chris
Microsoft MVP