Access 2000 - Keep form maximized

[Tony]

Hi All,

I'm trying to find a way to keep a form maximized no matter what users do.
I've tried MS's example of removing the restore button, and I've attempted
to maximize the form on resize, but I just can't get this figured out. Does
anyone have any pointers or sites with examples?

Thanks

 

[Brendan Reynolds]

Hi All,

I'm trying to find a way to keep a form maximized no matter what users do.
I've tried MS's example of removing the restore button, and I've attempted
to maximize the form on resize, but I just can't get this figured out.
Does anyone have any pointers or sites with examples?

Thanks

I haven't extensively tested this, as it's not something I would do or
recommend, but based on a quick limited test this seems to work ...

Option Compare Database
Option Explicit

Private m_Resized As Boolean

Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 240
End Sub

Private Sub Form_Resize()
m_Resized = True
End Sub

Private Sub Form_Timer()

If m_Resized Then

'for testing only, to see how frequently form gets resized
Debug.Print Now

DoCmd.Maximize
m_Resized = False
End If


End Sub

 

[Tony]

Brendan,

Thanks for the reply. I'll take a look and post back how things turn out.

Thanks

 

[Tony]

Brendan,

Works well. I'll probably drop the timer interval a bit but it's a nice
approach to something that's bothered me for a while. I've seen lots of
examples that grab the app & form size and resize things but I've never got
them to work quite right. However, this solution is short & sweet.

I really appreciate the help.

Ciao