Windowed Form

[roblowein]

Hi All,

New to Access .. so please bear with me.

I am trying to make a form .. so far so good ..its got all the data I
need. I just cannot see to make the form a window. In other words it
takes up all the screen room within access ... so there is a lot of
blank area in the form. I have looked into Pop-up and Modal and these
do not really give me what I need... though pop-up is the nearest ...
but I would like the flexibility to navigate round the rest of the
database .. at least for the moment.

Thanks in advance ..

Rob

 

[Arvin Meyer [MVP]]

In the Design View of the form, size it to fit your controls and save it. If
it still opens and covers the entire Access container, it is being opened
maximized. In the On Open event, create an [Event Procedure] that reads
like:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Restore
End Sub

 

[roblowein]

In the Design View of the form, size it to fit your controls and save it.If
it still opens and covers the entire Access container, it is being opened
maximized. In the On Open event, create an [Event Procedure] that reads
like:

Private Sub Form_Open(Cancel As Integer)
    DoCmd.Restore
End Sub
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

Hi All,

New to Access .. so please bear with me.

I am trying to make a form .. so far so good ..its got all the data I
need. I just cannot see to make the form a window. In other words it
takes up all the screen room within access ... so there is a lot of
blank area in the form. I have looked into Pop-up and Modal and these
do not really give me what I need... though pop-up is the nearest ...
but I would like the flexibility to navigate round the rest of the
database .. at least for the moment.

Thanks in advance ..

Rob- Hide quoted text -

- Show quoted text -

Hi ... Thanks for the reply

I think what I should have said is that when I have created the blank
form with all the fields etc ... its view / how it appears is in TAB
form rather than a window of any size .. does this make sense ?

Rob

 

[Arvin Meyer [MVP]]

I think what I should have said is that when I have created the blank
form with all the fields etc ... its view / how it appears is in TAB
form rather than a window of any size .. does this make sense ?

Try using an MDB instead of an ACCDB. I actually build my apps in A2003,
then port them to A2007 for those companies that use that version. It's
easier for me since I don't use the added features in A2007.

 

[roblowein]

In the Design View of the form, size it to fit your controls and save it. If
it still opens and covers the entire Access container, it is being opened
maximized. In the On Open event, create an [Event Procedure] that reads
like:

Private Sub Form_Open(Cancel As Integer)
    DoCmd.Restore
End Sub

- Show quoted text -

Hi ... Thanks for the reply

I think what I should have said is that when I have created the blank
form with all the fields etc ... its view / how it appears is in TAB
form rather than a window of any size .. does this make sense ?

Rob

resolved ...

I Needed to make the form property Movable ...ie set it to yes.
However It would not allow me to set it to Yes .. so I did the
following..


-Office Button
-Access Access Options
-Current Database
-Document Window Options select Overlapping Windows

All ok .. now all my forms can be windowed or tabbed (whole screen)

Thanks.