Saving Form Size in Aceess 2007

[JamesJ]

Is there a secret to saving a form's size in Access 2007???
I've tried many things but the form doesn't save the way I want. I've tried
setting the borders to sizable and then clicking the orb and selecting Save
while the form
is in normal view and have done the same from design view. I have the
AutoResize set to No.
This is an Overlapping form database. I didn't have this much problems
setting
the form size in other versions of Access.
Please tell me there is a rule of thumb when saving form sizes.

James

 

[Mark Andrews]

I'm not sure if that is fixed in one of the SPs, check allen browne's site.
I ended up using
DoCmd.MoveSize 0.7 * 1440, 0.7 * 1440, 8 * 1440, 6 * 1440
in the form_open event.

Hiting save in form design should do it, but I think it's a bug.

Mark
RPT Software
http://www.rptsoftware.com

 

[JamesJ]

I haven't the slightest idea. This is sp confusing I can't even begin to
explain it
in a post. There's no rhyme or reason to anything when it comes to sizing a
form in
an overlapping forms db.
I will resize by pulling the right border in about an inch and the the size
won't get saved.
I then pull the right border in 'till there is no room for any fieds to
display, ('til the form isn't anymore
than 1 inch wide) and it gets saved.
Sort of defeats the purpose.
btw, I have sp2 and the problem still exists.

 

[Albert D. Kallal]

I find that simply sizing a form in view mode and then hitting ctrl-s to
save. You then flip the form in design mode, and change the border style to
thin...and save again. This has worked well in every version of ms-access I
used, including 2007.


The ONLY EXCEPTION here is split forms....they don't save their size..and I
believe it is a bug....

So, try the above approach....

 

[Damon Heron]

Albert,
I followed your instructions exactly, and the form still doesn't size to the
original size I sized it in form mode. I'm with all the other posters in
that this does not work the way it used to. I use the resize event to
movesize my forms to the correct twips.
Damon

 

[JamesJ]

This is a split form. But I still can't seem to get it to work with other
forms.
I had one form after saving it the width was so large that it too me 5 times
to drag
the form acros the screen to get to the right border.
I can open a from up 3 different times and the form will have a different
width each time,
getting wider each time I open it. Corrupt form??

James

 

[Albert D. Kallal]

This is a split form. But I still can't seem to get it to work with other
forms.

As I said, split forms are a problem.

I can open a from up 3 different times and the form will have a different
width each time,
getting wider each time I open it. Corrupt form??

James

I am unable to re-produce this problem (except with split forms).

I am assuming you not using the tabbed interface, and are using overlapping
windows.

The forms border should be set to sizeable. You then while viewing the form
in regular view mode then set the size exactly the way you want. You then
hit ctrl-s. I also assumed that in design mode you shrunk down the detail
size to as small as possible).

Ok, so while in form view mode we have our size set and now hit ctrl-s. You
now flip form into design mode, and then change border style from sizeable
to thin. Now close the form.

However, before you do ANY of the above, make sure your settings are:

Auto center = yes (this does not matter either way)
Auto re-size = no
Fit to screen = no

If the above settings were wrong, then you have to open up the form in
design mode, and possible re-size the detail section. Perhaps you email you
me a simple form bound to a simple table that you can't re-size.

I am running access 2007 with sp2...

 

[JamesJ]

90% of my forms are split forms. The size gets very strange with these
forms.
After following your example, out of curiosity, and setting the border style
to
thin and open the form the width is, well, I can't even begin to figure how
wide it is.
it is off the screen by 8 or 9 screen widths.

Your procedure does work, however, with my non-split forms.

I guess I'll wait for a fix or resort to continuous forms.

James

 

[Dale_Fye via AccessMonster.com]

I've never used split forms (too many of my clients are still using 2003),
but I have a function that I call in the Load event of most of my forms. All
you have to do is pass it the height and width you want the form to be and it
takes care of it for you.

Private Sub Form_Load

SizeForm 4.5, 6

End Sub

Then put this in a code module

Public Sub SizeForm(FormHeight As Double, FormWidth As Double)

Dim frm As Form

Set frm = Forms(Forms.Count - 1)

frm.InsideHeight = FormHeight * 1440
frm.InsideWidth = FormWidth * 1440
DoCmd.Restore

End Sub

90% of my forms are split forms. The size gets very strange with these
forms.
After following your example, out of curiosity, and setting the border style
to
thin and open the form the width is, well, I can't even begin to figure how
wide it is.
it is off the screen by 8 or 9 screen widths.

Your procedure does work, however, with my non-split forms.

I guess I'll wait for a fix or resort to continuous forms.

James
[quoted text clipped - 32 lines]

I am running access 2007 with sp2...

 

[Albert D. Kallal]

90% of my forms are split forms. The size gets very strange with these
forms.

It is terrible how the split forms re-size. (well, they don't really re-size
correctly at all).

I *REALLY* like those split forms, but loss of sizing just really ruins this
fantastic new feature for me.

After following your example, out of curiosity, and setting the border
style to thin and open the form the width is, well, I can't even begin to
figure how wide it is. it is off the screen by 8 or 9 screen widths.

Yes, to me this is real mess-up. It simply bad...no other way to say
this....

Your procedure does work, however, with my non-split forms.

Thanks, I sized access forms for 10 years that way..it works well (except
for those new split forms!!).

I guess I'll wait for a fix or resort to continuous forms.

I just looking into making sure this has been submitted as a
bug/problem...(it can't possible be desired behavior).

 

[Dale_Fye via AccessMonster.com]

Albert,

I cannot think of an occassion where I would want to do this. Maybe it's 14
years of developing in Access, but I would think the loss of valuable screen
realestate is a waste.

Dale

 

[JamesJ]

I agree. I like the split forms but only in a tabbed interface.

James

 

[Albert D. Kallal]

Albert,

I cannot think of an occassion where I would want to do this. Maybe it's
14
years of developing in Access, but I would think the loss of valuable
screen
realestate is a waste.

Dale

Dale, please do expand on this. I am interested. Are you saying that this
issue not a problem for you? (by the way, that 100% fine here...I just
interested here).

In all of my access applications I have always pre-sized my forms, and
removed the user ability to change/re-size.

Having said the above, access 2007 is a REALLY nice step forward in that
controls and text boxes can be anchored and RE-SIZE when the form re-sizes.
In addition I kind of like the tabbed forms, and again this means that forms
take on the size of the application. and NO grey access background can be
seen.

So, I can WELL see an agree with your point of view.

However, having said the above, all forms except that split form can be
sized and saved exactly the way I want them to be....I just think the split
forms should also respect that size I give them. This of course means I
don't run my forms maximized. As mentioned, I likely to consider changing
the long time development process due to re-sizing ability of access 2007
forms.

The problem was in pre-2007 versions, a maximied form on larger screens
simply did not look good....

 

[Dale_Fye via AccessMonster.com]

Albert,

I'm still mostly using 2003, since most of my clients are still using 2003.

In that environment, I generally design my forms with fixed sizes, to the
screen with the lowest resolution, which, unfortunately means that those
using high resolution monitors end up viewing the applications in a smaller
portion of their overall screen realestate. In many of these applications, I
also hide the Access window, so all the users sees are my forms and reports,
without the Access border. I frequently use the tab control.

I've only recently started taking advantage of Access 2007s ability to resize
and anchor. I'm still getting used to that functionality, but really like it.


What I don't understand is the utility of the split form. It seems to me
that displaying the data in datasheet format (which I almost never do in my
applications) along side of a form just seems like a waste of screen space to
me. I guess I just need to see it in use a couple of times before I'm
convinced of its utility.

Dale

Albert,

[quoted text clipped - 5 lines]

Dale

Dale, please do expand on this. I am interested. Are you saying that this
issue not a problem for you? (by the way, that 100% fine here...I just
interested here).

In all of my access applications I have always pre-sized my forms, and
removed the user ability to change/re-size.

Having said the above, access 2007 is a REALLY nice step forward in that
controls and text boxes can be anchored and RE-SIZE when the form re-sizes.
In addition I kind of like the tabbed forms, and again this means that forms
take on the size of the application. and NO grey access background can be
seen.

So, I can WELL see an agree with your point of view.

However, having said the above, all forms except that split form can be
sized and saved exactly the way I want them to be....I just think the split
forms should also respect that size I give them. This of course means I
don't run my forms maximized. As mentioned, I likely to consider changing
the long time development process due to re-sizing ability of access 2007
forms.

The problem was in pre-2007 versions, a maximied form on larger screens
simply did not look good....

 

[Albert D. Kallal]

What I don't understand is the utility of the split form. It seems to me
that displaying the data in datasheet format (which I almost never do in
my
applications) along side of a form just seems like a waste of screen space
to
me. I guess I just need to see it in use a couple of times before I'm
convinced of its utility.

It is a nice navigation system that can be built with ease. You get to move
through a datasheet, and then the detail form displays the record in an form
that can be edited. So, not really a drill down, but it saves one having to
build a sub-form + form. For example the following screen shots (last one)
shows a continues form at the top, and as the user moves through the
records, the form on the button displays that info...that is what a split
form does without any coding.

http://www.members.shaw.ca/AlbertKallal/Search/index.html
(look at last screen shot).

The above was done with coding, but the idea of a datasheet + form to edit
is a common layout.

Note that the split form allows top, left, right, or bottom for placement of
the datasheet. So, having a list of records on the left side, and form on
the right works rather well for wide screen monitors.

However, at the end of the day...I not used a split form as of yet, and my
designs simply don't incorporate them in my thinking at all....

Your experience is much like mine, and I think it the "new" users of access
the ones that really jumped on those split forms. I suspect that users would
not like going back to previous versions!!!