That maximizes the active window within the application window, not the
application window. I understood the requirement to be the application
window. That is the behavior in access 97 and 2000. I don't think it would
change in later versions.

--
Regards,
Tom Ogilvy

immanuel wrote in message
...
Thanks for the correction, Tom. :)

In 2003, it seems that you can just call Appliation.DoCmd.Maximize. Is
this
not the case previous versions?

Regards,
Immanuel

"Tom Ogilvy" wrote in message
...
I believe that is the Excel method, but it is not available in Access:


http://support.microsoft.com/default...90&Product=acc
ACC2000: How to Use Visual Basic for Applications to Minimize, Maximize,
and
Restore Access


http://support.microsoft.com/default...34&Product=acc
ACC: How to Minimize, Maximize, and Restore MS Access 95/97

At least not in Acc 95 - 2000

--
Regards,
Tom Ogilvy


immanuel wrote in message
...
Try:

accessApp.WindowState = -4137

/i.

"hlam" wrote in message
news:DAwtb.52959$jy.12728@clgrps13...
My excel file is to close itself after access is called, however the
access
file is not opened in full window size. How can I modify the code
in
order
to have the access window in full size?

Sub OpenDatabaseFile()

Dim accessApp As Object

Set accessApp = CreateObject("Access.Application.9")

With accessApp
.OpenCurrentDatabase ("D:\db1.mdb")
.Visible = True
End With

Set accessApp = Nothing

ThisWorkbook.Close

End Sub