viewing form full screen

  • Thread starter Thread starter Pat
  • Start date Start date
If you just want the form to fill the entire Access window, you can do this:
Open the form in design view.
Display the form's Property Sheet.
Scroll down to the entry for OnOpen.
Highlight that entry, and click the down arrow at the right of the box.
Select [Event Procedure].
Now click on the button with 3 dots at the end of that line.
A code window will open, with the cursor between these two lines:
Private Sub Form_Open(Cancel as Integer)
End Sub
Between those two lines, type this:
DoCmd.Maximize

You should now be able to close that (code) window, and save your form.
Now when you open it, it will fill the entire Access Window.

If you are thinking of either making the Access Window fill the entire
screen, or displaying your form without the Access window, be aware that
while these things can be done by advanced programmers, they do not
constitute "baby steps".

HTH
- Turtle
 
mine says Private Sub Detail_Click ()
End Sub

with the bits above it for my combo search box. Wld i substitute the command
u gave me?
this is a database going into a salon where the pc operator is not pc
literate and i thght it wld be easier if she cldn't see the access toolbar.
but maybe not? if it opens full screen, do i get out of it with esc as in
word, or not?
thanx for the promp answer
cheers pat
 
It looks as if you displayed the property sheet for the detail section, not
for the entire form.
On the Design View of your form, there's a gray square where the top and
left rulers meet.
Click on that (a black square appears inside the gray one), then click on
the Properties button on the toolbar to show the Properties Sheet for the
Form.
(There are many other ways of doing this - main thing is to make sure the
title bar of the Property Sheet says Form.)
Then scroll down to OnOpen.
If you don't see OnOpen in the property sheet, you probably don't have the
right property sheet open.

I'd strongly recommend leaving the Access window.
Before you deliver your application, you might want to click on Tools -
Startup.
Remove the checks in all the checkboxes, and set your form as Startup
Form.
(If you do this before you're finished, you'll probably need to use the
Startup Bypass Key to open your application in a state where you can work on
it effectively.)

HTH
- Turtle
 
Back
Top