Pop up Forms

C

COB

Registered User.

Local time

Today, 16:54

Joined

Mar 7, 2003

Messages

19

• Mar 25, 2003

• #1

I'm in need of help, does anybody know how to keep a form at a certain size without using the Pop Up option in the properties box. If I use the Pop Up option I'm no longer able to delete the record but instead I'm asked to delete form that is selected in the database window. Confusing!!!

If I don't use the pop up option, i unable to keep the form at 4.35x2 dimension but instead the form fills out the full form.

Any help will be much appreciated.
Thank you very much.
Regards
Cormac

 

ghudson

Registered User.

Local time

Today, 11:54

Joined

Jun 8, 2002

Messages

6,194

• Mar 25, 2003

• #2

Using the InsideHeight & InsideHeight properties in the forms OnOpen event will
enable you to control the size of your forms. You just need to play around with
the "twips" to get the size you want.

Code:

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open
    
'   For testing the size of the form OnOpen
'   MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth
    InsideHeight = 4605
    InsideWidth = 7950
    
Exit_Form_Open:
    Exit Sub
    
Err_Form_Open:
    MsgBox Err.Number & " - " & Err.Description
    Resume Exit_Form_Open
    
End Sub

HTH

 

C

COB

Registered User.

Local time

Today, 16:54

Joined

Mar 7, 2003

Messages

19

• Mar 25, 2003

• #3

Thanks

Thanks for that but it still wants to maximise the window!!
Although when I have the pop up it goes to the dimensions that you set but as soon as I deactivate the Pop Up option it just fills the whole screen...
Do you have any other hints!!!
Thanks
COB

 

R

Rich

Guest

• Mar 25, 2003

• #4

Try the DoCmd.MoveSize method

 

ghudson

Registered User.

Local time

Today, 11:54

Joined

Jun 8, 2002

Messages

6,194

• Mar 25, 2003

• #5

Somewhere you are running the Maximize command (or macro) for your popup form. You need to remove it to prevent the form from 'maximizing'.

HTH

 

C

COB

Registered User.

Local time

Today, 16:54

Joined

Mar 7, 2003

Messages

19

• Mar 25, 2003

• #6

Me Again!!!

Ok I've done what you have said..
I've checked for the maximise option-- No
I've used the Movvesize and I've used the InsideHeight/Weight both of them work when I use the text boxes on there own, but as soon as I try to add command buttons to the form, the form just maximises... and it doesn't listen to the code that I have in the form load...

DoCmd.MoveSize 2400, 1250, 6200, 2600

Any help is much appreciated.
Thanks in advance.
COB

 

Idjit

Clamoring Preschooler

Local time

Today, 11:54

Joined

Apr 18, 2002

Messages

216

• Mar 25, 2003

• #7

In the form's properties, set AutoResize to "No" and make sure Border Style is not "None".

 

C

COB

Registered User.

Local time

Today, 16:54

Joined

Mar 7, 2003

Messages

19

• Mar 25, 2003

• #8

Ok I'm still stuck...
I created another database to see if it would work and of course it works in that, I imported the two forms that connect each other and it works in the test db but as soon as I try it in the original,,, it just maximises... any ideas???
COB