OpenForm

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan T - 22 May 2007 02:25 GMT

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?

Reply to this Message

Steve - 22 May 2007 15:42 GMT

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
Resource@PCDatasheet.Com

> 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?

Reply to this Message

Alan T - 23 May 2007 05:28 GMT

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.
[quoted text clipped - 12 lines]
>> I noticed the form opened is wider than what at design time.
>> Can I open the form the same layout as at design time?

Reply to this Message

Alan T - 23 May 2007 06:02 GMT

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

> Thanks
>
[quoted text clipped - 14 lines]
>>> I noticed the form opened is wider than what at design time.
>>> Can I open the form the same layout as at design time?

Reply to this Message

Maurice - 22 May 2007 18:37 GMT

Hi Alan,

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

Signature

Maurice Ausum

Reply to this Message

strive4peace - 23 May 2007 10:56 GMT

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
*

Reply to this Message

missinglinq - 23 May 2007 11:50 GMT

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."

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message

Alan T - 24 May 2007 06:11 GMT

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

>I have to ask this, because I've seen it drive noobies carzy before! When
>in
[quoted text clipped - 7 lines]
> double headed arrow, Left Click and hold, then move the border over to the
> edge of the "pegboard."

Reply to this Message

strive4peace - 24 May 2007 06:16 GMT

good point!

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.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
[quoted text clipped - 3 lines]
> double headed arrow, Left Click and hold, then move the border over to the
> edge of the "pegboard."

Reply to this Message