>> Status Bar

[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

 

[Marshall Barton]

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

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.

 

[ruralguy via AccessMonster.com]

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.

 

[Marshall Barton]

Of course. Thanks for the reminder, RG.

And for Jonathan, the answer is GetOption