A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form Width Grows



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2010, 02:58 PM posted to microsoft.public.access.forms
Kaykayme
external usenet poster
 
Posts: 13
Default Form Width Grows

I have Access 2007 and am using the anchor feature on some of my controls. I
have the form set at popup=true, auto center=true, auto resize=false, fit to
screen=false, border style=thin, moveable=true and the windows are set to
overlapped instead of tabbed. I set the form to the exact size that I want
it and saved it before setting the border style=thin and popup=true. The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and reset
the form's width. This is happening on several of my forms with the same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.
  #2  
Old March 11th, 2010, 07:31 PM posted to microsoft.public.access.forms
TekWarrior
external usenet poster
 
Posts: 10
Default Form Width Grows

Try Popu=False, I think that may be your issue, but I would have to test and
don't have Access to my Access 2007 right now (no pun intended).
--

Thanks,
Tek


"Kaykayme" wrote:

I have Access 2007 and am using the anchor feature on some of my controls. I
have the form set at popup=true, auto center=true, auto resize=false, fit to
screen=false, border style=thin, moveable=true and the windows are set to
overlapped instead of tabbed. I set the form to the exact size that I want
it and saved it before setting the border style=thin and popup=true. The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and reset
the form's width. This is happening on several of my forms with the same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.

  #3  
Old March 11th, 2010, 08:22 PM posted to microsoft.public.access.forms
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Form Width Grows

I can't remember if that is a pre SP2 bug or not? However if all else fails
resort to something like this:

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 0.7 * 1440, 0.7 * 1440, 8 * 1440, 6 * 1440

End Sub

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com


"Kaykayme" wrote in message
...
I have Access 2007 and am using the anchor feature on some of my controls.
I
have the form set at popup=true, auto center=true, auto resize=false, fit
to
screen=false, border style=thin, moveable=true and the windows are set to
overlapped instead of tabbed. I set the form to the exact size that I
want
it and saved it before setting the border style=thin and popup=true. The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and reset
the form's width. This is happening on several of my forms with the same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.


  #4  
Old March 12th, 2010, 03:20 PM posted to microsoft.public.access.forms
Kaykayme
external usenet poster
 
Posts: 13
Default Form Width Grows

Thank you for your help. As I mentioned before this happens on several of my
forms. Some of the forms are set popup=false and I still have the problem.

"TekWarrior" wrote:

Try Popu=False, I think that may be your issue, but I would have to test and
don't have Access to my Access 2007 right now (no pun intended).
--

Thanks,
Tek


"Kaykayme" wrote:

I have Access 2007 and am using the anchor feature on some of my controls. I
have the form set at popup=true, auto center=true, auto resize=false, fit to
screen=false, border style=thin, moveable=true and the windows are set to
overlapped instead of tabbed. I set the form to the exact size that I want
it and saved it before setting the border style=thin and popup=true. The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and reset
the form's width. This is happening on several of my forms with the same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.

  #5  
Old March 12th, 2010, 04:47 PM posted to microsoft.public.access.forms
Kaykayme
external usenet poster
 
Posts: 13
Default Form Width Grows

Thank you Mark. Does this docmd limit the size of the form to only these
specifications or is this generic? If specific I would have to include this
code for every form to meet it's specific size. There must be an easier way.

"Mark Andrews" wrote:

I can't remember if that is a pre SP2 bug or not? However if all else fails
resort to something like this:

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 0.7 * 1440, 0.7 * 1440, 8 * 1440, 6 * 1440

End Sub

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com


"Kaykayme" wrote in message
...
I have Access 2007 and am using the anchor feature on some of my controls.
I
have the form set at popup=true, auto center=true, auto resize=false, fit
to
screen=false, border style=thin, moveable=true and the windows are set to
overlapped instead of tabbed. I set the form to the exact size that I
want
it and saved it before setting the border style=thin and popup=true. The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and reset
the form's width. This is happening on several of my forms with the same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.


.

  #6  
Old March 12th, 2010, 09:15 PM posted to microsoft.public.access.forms
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Form Width Grows

It's specific, but will work. Only use if you can't get Access to remember
the form size. Do you have SP2?


"Kaykayme" wrote in message
...
Thank you Mark. Does this docmd limit the size of the form to only these
specifications or is this generic? If specific I would have to include
this
code for every form to meet it's specific size. There must be an easier
way.

"Mark Andrews" wrote:

I can't remember if that is a pre SP2 bug or not? However if all else
fails
resort to something like this:

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 0.7 * 1440, 0.7 * 1440, 8 * 1440, 6 * 1440

End Sub

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com


"Kaykayme" wrote in message
...
I have Access 2007 and am using the anchor feature on some of my
controls.
I
have the form set at popup=true, auto center=true, auto resize=false,
fit
to
screen=false, border style=thin, moveable=true and the windows are set
to
overlapped instead of tabbed. I set the form to the exact size that I
want
it and saved it before setting the border style=thin and popup=true.
The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and
reset
the form's width. This is happening on several of my forms with the
same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.


.

  #7  
Old March 16th, 2010, 05:18 PM posted to microsoft.public.access.forms
Kaykayme
external usenet poster
 
Posts: 13
Default Form Width Grows

Yes I have SP2. I don't think this will solve the problem.

"Mark Andrews" wrote:

It's specific, but will work. Only use if you can't get Access to remember
the form size. Do you have SP2?


"Kaykayme" wrote in message
...
Thank you Mark. Does this docmd limit the size of the form to only these
specifications or is this generic? If specific I would have to include
this
code for every form to meet it's specific size. There must be an easier
way.

"Mark Andrews" wrote:

I can't remember if that is a pre SP2 bug or not? However if all else
fails
resort to something like this:

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 0.7 * 1440, 0.7 * 1440, 8 * 1440, 6 * 1440

End Sub

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com


"Kaykayme" wrote in message
...
I have Access 2007 and am using the anchor feature on some of my
controls.
I
have the form set at popup=true, auto center=true, auto resize=false,
fit
to
screen=false, border style=thin, moveable=true and the windows are set
to
overlapped instead of tabbed. I set the form to the exact size that I
want
it and saved it before setting the border style=thin and popup=true.
The
form initially has the correct size but overtime the form begins to get
wider. After some time of opening it I eventually have to go in and
reset
the form's width. This is happening on several of my forms with the
same
settings. Is there something I am overlooking?

Thanks for your help with annoying problem.

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.