 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2006>> Status Bar
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 >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.  SignatureMarsh MVP [MS Access] 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. >>Hi, in Excel you can use the line application.displaystatusbar to check >>whether the status bar is visible. What is the Access equivilant? [quoted text clipped - 11 lines] >If that causes a property not found error (3270), I presume >that the status bar is being shown. SignatureHTH - RuralGuy (RG for short) acXP WinXP Pro Please post back to this forum so all may benefit. Of course. Thanks for the reminder, RG. And for Jonathan, the answer is GetOption SignatureMarsh MVP [MS Access] >Hi Marsh, >I'm pretty sure that if you start your application with the Status bar ON [quoted text clipped - 20 lines] >>If that causes a property not found error (3270), I presume >>that the status bar is being shown. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.