Full Size

[UT227]

I have a main menu that comes up when my database opens. I want it to go to full screen and stay that way. Is there a setting for that?

[ranman256]

in the macro , autoexec,
openform mainform
maximize

[Missinglinq]

By 'full screen' do you mean so that even the Access shell (ie Navigation Pane, Ribbon, etc.) doesn't show?

Linq ;0)>

[UT227]

I didn't think about not letting the Ribbon show. I would like to try that. Also, I get to the main menu through a login form. Here's the code for the login.

Private Sub Command0_Click()

On Error GoTo Err_Handler

If IsNull(txtUsername) Then
MsgBox "Invalid username"
Exit Sub
End If
If IsNull(txtPassword) Then
MsgBox "Invalid Password"
Exit Sub
End If
Dim X As Long
X = Nz(DLookup("EmployeesID", "qryEmployeesCurrent", "Username='" & txtUsername & "' AND Password='" & txtPassword & "'"))

If X > 0 Then
' We have a valid user
DoCmd.OpenForm "frmMainMenu"
Forms!frmMainMenu!txtUserID = X
Forms!frmMainMenu!txtUsername = txtUsername
DoCmd.Close acForm, "frmLogin"
Else
MsgBox "invalid Login"
End If

Exit_Handler:
Exit Sub

Err_Handler:
If Err = 3078 Then
MsgBox "The network connection is currently not available." & vbCrLf & _
"Please try again later ..." & vbCrLf & vbCrLf & _
"This application will now close", vbExclamation, "Network error"
Application.Quit
Else
MsgBox "Error " & Err.Number & " in frmLogin Command0_Click procedure: " & Err.Description, vbCritical, "Program Error"
GoTo Exit_Handler
End If
End Sub

[isladogs]

If you want to maximise your form, just use DoCmd.Maximize in the Form_Load event

For info on hiding one or all of the ribbon, nav pane, access application window & taskbar, see my example database https://www.accessforums.net/showthread.php?t=69856

[UT227]

Perfect. Thanks.