Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Form opens up in big size

Hello All,

I have a form and when i go to design view > form properties
i have set it autosize = no
and saved it

When i open the form in datasheet mode, it always shows up in big size?

Can anyone indicate whats happening and how this could be fixed
AUTOSIZE-ISUUE.png
0
Rayne
Asked:
Rayne
  • 3
1 Solution
 
RayneAuthor Commented:
i have set its default mode to be in datasheet
0
 
RayneAuthor Commented:
and i am opening the form via a button like this
DoCmd.OpenForm "tblmyStuff
0
 
NorieData ProcessorCommented:
Have you tried resizing the form/datasheet view before you save?
0
 
duttcomCommented:
You may have tabbed documents turned on.

Go to Options -> Current Database -> under Application optins at the top you will see Document Window Options. If the Tabbed Documents option is checked, the form will always open maximised. The Overlapping Windows option will allow the form to open at your desired size.

You may need to change the option then close and reopen the database to see the change in window options.
0
 
RayneAuthor Commented:
thank you duttcom, thank you
This is life saver
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now