>> Status Bar

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

Guest

Hi, in Excel you can use the line application.displaystatusbar to check
whether the status bar is visible. What is the Access equivilant?

Many thanks
Jonathan
 
Jonathan said:
Hi, in Excel you can use the line application.displaystatusbar to check
whether the status bar is visible. What is the Access equivilant?
Click to expand...


Interesting question. The status bar is shown or hidden at
startup, but I was unable to find a way to toggle this
property while an applicataion is running, only takes
effect the next time the application is opened.

You can get the startup setting of the status bar with this
reference:

CurrentDb.Containers!Databases.Documents!MSysDb.Properties!StartUpShowStatusBar

If that causes a property not found error (3270), I presume
that the status bar is being shown.
 
Hi Marsh,
I'm pretty sure that if you start your application with the Status bar ON
then you can toggle it on and off with:
Application.SetOption "Show Status Bar", True
Application.SetOption "Show Status Bar", False

If you don't have "Display Status Bar" checked in the startup dialog then
this method does not work.
 
Of course. Thanks for the reminder, RG.

And for Jonathan, the answer is GetOption
 
Back
Top