hide status bar in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form to edit multiple records by using Recordset on the basis of a
query, I don't want to show the status bar which there is no actual link
between the status bar and the recoreds at this case, I unchecked the
"Display Database Window" and "Display Status Bar" in the startup dialogue
for the form, but when I run the form, it still shows the status bar, how can
I hide the status bar?

any help would be great, thank you very much in advance!
 
Hi Dennis, thanks a lot for your help, but I tried to untick the "Show Status
Bar" in the View Tab in the option, it hides the status bar for the whole
database but not the form's status bar which is not I want....

any other ways ?

I really appreciate your help!
 
In the On Open event of the form put this code

Application.SetOption "Show Status Bar",False

In the On Close event of the form put this code

Application.SetOption "Show Status Bar",True
 
Hi Dennis, thank you so much for your help! I tried the second coding way and
the form still shows me the status bar about the record numbers moving
previous or next, I couldn't understand what's wrong with my form? maybe I
need to try other ways...

Thank you very much anyway! I really appreciate your help!
 
Perhaps you ALSO want to disable controls like "Record Selectors" and
"Navigation Buttons"; these are properties of your Form, and they don't
need to be set globally. Just open your Form in Form Design View,
right-click in its upper left corner, and left-click on Properties.
Change the values of the properties you wish to change (there are
several there; the ones you want are probably all on the Format tab).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
lily said:
Hi Vincent,

It works! Thank you so very much! I really appreciate your help!
Click to expand...

You're most welcome. Note that various subsets of a Form, such as the
Detail Section, have their own Property Sheets, and you may find some of
those properties useful to you as well.
 
Thanks again !

Vincent Johns said:
You're most welcome. Note that various subsets of a Form, such as the
Detail Section, have their own Property Sheets, and you may find some of
those properties useful to you as well.
Click to expand...
 
Back
Top