Trouble to get the fixed size of the Access form when it open

Question

I created a Access form and get the good size in design view but it become the much bigger when I open it.  I can't find the right property to do get it fixed.  As I remember, I don't need do anything in my other Access Database form.  it become the size as my design view without issue.

Thanks!

Answer 1

I created a Access form and get the good size in design view but it become the much bigger when I open it.  I can't find the right property to do get it fixed.  As I remember, I don't need do anything in my other Access Database form.  it become the size as my design view without issue.

Hi Daphne,

You can adjust the dimensions of the form as it is displayed. Then save the changes.

Imb.

Answer 2

It might be, AutoResize, on the form properties of the Format tab.

Answer 3

... but it become the much bigger when I open it.

How much bigger? Does it occupy the whole screen/window (maximized)? If so, you can either set the PopUP property to Yes or change your Document Window Options to "Overlapping Windows" (if it's set to Tabbed Documents).

Hope it helps...

Answer 4

It works. Thanks for all!

Answer 5

Excellent! Continued success with your project.

Answer 6

Yes! I have the Access report open . but it opens in the behind of the form. Anyway have it open over the main form?

Answer 7

If your form is a popup, you can also make the report a popup to show it on top. Otherwise, you can "hide" the form before opening the report by using something like:

Me.Visible = False

Just make sure you show it again when you close the report. To show the form again, you can either set Visible to True or simply use the OpenForm method to open the form again.

Hope it helps...

Answer 8

Excellent! Pop up set 'Yes'. You're the BEST!  Thanks a lot!!

Answer 9

Excellent! Pop up set 'Yes'. You're the BEST!  Thanks a lot!!

Hi,

You're welcome! We're all happy to assist. Cheers!

Answer 10

Question about button, My regular button looks different action button. Back color: #FFFFFF fore color: System Button Text. These Action button (Add New, Delete, Save) default as light blue as back Accent 1, Lighter 40% and fore color: Text 1, Lighter 25%

I can't make them same looks in the same Access Database. 

Answer 11

Hi Daphne,

Try the following steps:

1. Select the button with the correct color you want to copy

2. Click on the Format Painter icon on the Home Ribbon (see image below)

3. Click on the button you want to change the color

4. Repeat above steps for other buttons you want to make the same color

Hope it helps...

Answer 12

Thank you! Got it!

Answer 13

Yay! Congratulations!

Answer 14

After the message box, I need focus back to the "wrong input" text box.

txtEmpID.GotFocus doesn't work n Access.