OpenForm

[Alan T]

This is I am using to open a form:
DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal

I noticed the form opened is wider than what at design time.
Can I open the form the same layout as at design time?

 

[Steve]

Open your form in design view. Click on the properties icon in the menu at
the top of the screen. In the dialog that opens, click on the Other tab.
Change the Pop Up property to Yes. Now open your form in form view. You can
grab the edges and drar the edge of the form to make the form whatever size
you want.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Maurice]

Hi Alan,

Have your tried 'size to fit form' yet? (under view)

 

[Alan T]

Thanks

Open your form in design view. Click on the properties icon in the menu at
the top of the screen. In the dialog that opens, click on the Other tab.
Change the Pop Up property to Yes. Now open your form in form view. You
can grab the edges and drar the edge of the form to make the form whatever
size you want.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Alan T]

Oh sorry, it does not work now.
Not sure what I did.

 

[strive4peace]

Hi Alan,

when you are designing your form, you have to take into account the
extra things that show in the design view (like section bars and rulers)
-- so you need to make the form a tad bit narrower and shorter than what
you think the size should be -- save the form in design view and that
will be the size in form view -- go back and forth a little until you
get a feel for what it should be. Size the window so everything just
shows and then close up the space a little

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[missinglinq via AccessMonster.com]

I have to ask this, because I've seen it drive noobies carzy before! When in
Design View, you're not assuming that the width of the form is the width of
the pegboard looking area, are you? The width is actually going to be that of
the window holding the form. To get them to the same size, you need to move
your cursor to the right edge of the container window until it becomes a
double headed arrow, Left Click and hold, then move the border over to the
edge of the "pegboard."

 

[Alan T]

Yes, I think I just resize the outside edge.
Now I can shrink the width of the 'form'.

 

[strive4peace]

good point!

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*