form opening incorrectly

[defosset]

i am setting up a data base and i have maximized my form to all corners of the screen when i design them but when they open in data sheet view they are not maximized and you can see the grey back ground screen, what setting do i need to change on each form so they open fully on the screen.

thanks
ND

 

[Remou]

Hi
How about:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

 

[defosset]

this worked but when you go to another page and come back to that page it is off center what scripting do i need to add to keep it centered.

 

[PHV]

Set the AutoCenter property of the form to True.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886