Share via

How do I keep/set a form size when Access changes it? (DAO)

Anonymous
2017-01-15T19:41:21+00:00

My program's switchboard is supposed to be set at Width 5.5833 and (detail) height 4.0.  When Access opens the switchboard, it doubles or triples the form's dimensions, most of it being blank, and the business part of the objects where they are supposed to be in the upper left corner of the form.  I've tried saving the form in design view and using me.form.width = 5.5833 (and) me.detail.height = 4.0  (Access changes the  4.0 to 4# so I know he's listening to me).  Neither works.  Googling only gets me to movies on how to resize objects, and that isn't what I need.

Any help?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2017-01-15T20:08:01+00:00

That depends on several factors. For example if you're using tabbed windows rather than overlapping, they will all be the size of the Access container.

If using overlapped, then the next property is AutoResize which should be True.

Was this answer helpful?

2 people found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2017-01-15T20:32:19+00:00

    Thanks a bunch, Tom.  That saves me a lot of grief. 

    Incidentally, it seems to work on both tabbed and overlapping.

    Was this answer helpful?

    0 comments No comments