Form Width

[tboggs25]

I have a form with an embedded picture as the background - stretch
horizontally. The width of the form is at 8.0417" in design view; however,
in the form view it is much wider with a huge empty space to the right off
all my input boxes.

Does anyone have any ideas as to why? The background picture is much
smaller than the width that the form magically grows to in form view.

Here are some additional settings that may give someone a idea as to what is
wrong:
Pop-up: yes
modal: yes
auto center: yes
fit to screen: yes (i've tried both yes and no)
border style: thin
record selectors: no
naviation buttons: no
dividing lines: no
scroll bars: vertical only (the form is long, but even when i delete
everything and try to make it tiny it still comes out the same size - hence
why i think it is a setting)

control box: no
close button: no
min max buttons: no
moveable: yes

 

[Erez Mor]

hi
the missing propery is AutoSize, and if you set it to False, the size of the
form will be the same as it was when you last designed it (edited it in
design view) and will not change (and therefore i would suggest to change
FitToScreen to false as well)

Erez

 

[tboggs25]

Sorry, I did leave that property out. I have Access 2007 and the property I
see is Auto Resize - I have that set to no.

I also have Fit to Screen set to no.


The form still expands horizontally much bigger than the size in design
view. Any other ideas?

Thanks in advance for your help!

 

[tboggs25]

Alright, here is what I did.

Auto Resize - Yes
Fit to Screen - Yes
Border Style - Sizable

This fixes the width of my form and gives me the vertical scroll bar that I
wanted; however, now the height of my form fills up the entire screen. I
would like to control the height of my form and just let the user scroll down.

How do I do that? I'm not seeing any properties

Thanks in advance!

 

[jp]

I saw in another post that if you use the VBA code "Me.Move" you can
control the location and dimensions of your form. Go to design view and
click build code under the On Load event.

Hope this helps