Access forms as a window

[Rob]

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

 

[Peter's Software]

Rob,

Try putting a

DoCmd.Restore

.... in your form OnOpen event procedure (not the event property. Click
the "..." button next to the event property to build an event
procedure).

Hope this helps,

Peter De Baets
http://www.peterssoftware.com

 

[roblowein]

Rob,

Try putting a

DoCmd.Restore

... in your form OnOpen event procedure (not the event property. Click
the "..." button next to the event property to build an event
procedure).

Hope this helps,

Peter De Baetshttp://www.peterssoftware.com

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

 

[roblowein]

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.