Pop-up form is too small!

[Andrew]

Hi all

I have a problem which I've encountered a few times over the years.
It's normally not too hard to resolve, and yet this time it's got me
beaten. Tried doing searches on Google and in this group, but to no
avail... Surely I can't be alone in this?

My database is an mdb file, being developed on Access 2007 (my client
is using A2003).

I have a form which is designed to act as a pop-up form, showing
records which a user must manually correct.

However, when the form is opened, it opens at about 1cm wide by 1cm
tall... making everything on it inaccessible. Furthermore, I'm unable
to resize the form at this point, even if the border style is set to
sizeable.

The form has the following properties (hopefully I've included all
those which are salient):

Default view: Continuous Forms
Auto Center: Yes
Auto Resize: No
Fit to screen: No
Border style: Sizable
Scroll bars: Both
Control Box: No
Close Button: No
Min Max buttons: No
Moveable: No
Popup: Tried yes and no - see later
Modal: No

The code which opens the form is as follows:

DoCmd.OpenForm FormName:="fpopItemsWithoutLabels",
WindowMode:=acDialog, View:=acNormal

I've also tried using this code:

Dim frm as form
Set frm= new form_fpopItemsWithoutLabels
frm.visible=true

but even with the form's Modal property set to True, the form isn't
modal, therefore the code continues to run in the background (with bad
results!) rather than waiting for the user to close this form before
continuing.

I originally had the popup property set to Yes, but wondered if the
"double-positive" of having it set to yes, and the WindowMode set to
acDialog would cause an issue, so have it currently set to no.

In the past when I've had this problem, I've simply gone into Design
view, saved the form at the appropriate size (ie not with the form in
maximized state), checked the various properties above, and it's
sorted itself out. However, with this one, it seems sorted, but when I
use it again, we're back to a tiny and unusable form.

In the process of trying to resolve the issue, I've tried setting:

Moveable to both Yes and No
Border style to both Dialog and Sizeable
Popup to Yes and No
Modal to Yes and No

HEEELLLPP!! Before I go mad. Again.

Thanks very much - if I've missed any information, let me know!

Regards
Andrew

 

[Dale Fye]

I've encountered this occassionally.

What I've started doing is using the forms Open event to manually set the
forms insideheight and insidewidth characteristics. Something like:

Private sub Form_Open

me.visible = true
me.insideheight = 4 * 1440
me.insidewidth = 6 * 1440

end sub

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

I've also found that setting the forms Popup and Modal properties to false,
manually sizing the form in design view, then saving it.

Then opening it back up in design view and settin the popup and modal
properties sometimes works.
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Andrew]

I've encountered this occassionally.

What I've started doing is using the forms Open event to manually set the
forms insideheight and insidewidth characteristics.  Something like:

Private sub Form_Open

    me.visible = true
    me.insideheight = 4  * 1440
    me.insidewidth = 6 * 1440

end sub

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

Perfect - that seems to have done the job...

Sanity saved - thank you very much!

Andrew