By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

How to display a specific text in the MS Access Status Bar

P: 2
The command doCmd.Echo or Application.Echo are not enabling to display a specific text in my MS Access Status Bar.
Any particular additional actions not specified in the MS Access Std Help?
Mar 8 '17 #1

✓ answered by PhilOfWalton

Something like
Expand|Select|Wrap|Line Numbers
  1. Call SysCmd(acSysCmdSetStatus, "Checking for an internet connection...")
  2.  
Sets the status bar

and

Expand|Select|Wrap|Line Numbers
  1. Call SysCmd(acSysCmdClearStatus)
  2.  
Removes it

Read up on the SysCmd function as you can also use the status bar as a progress meter.

I personally find the status bar is a bit insignificant, so I use my own version.


Phil

Share this Question
Share on Google+
3 Replies


PhilOfWalton
Expert 100+
P: 1,430
Something like
Expand|Select|Wrap|Line Numbers
  1. Call SysCmd(acSysCmdSetStatus, "Checking for an internet connection...")
  2.  
Sets the status bar

and

Expand|Select|Wrap|Line Numbers
  1. Call SysCmd(acSysCmdClearStatus)
  2.  
Removes it

Read up on the SysCmd function as you can also use the status bar as a progress meter.

I personally find the status bar is a bit insignificant, so I use my own version.


Phil
Mar 8 '17 #2

P: 2
Thks, it was useful !
Hope to be able to return the favor.
Mar 8 '17 #3

jforbes
Expert 100+
P: 1,107
I use this function to simplify things:
Expand|Select|Wrap|Line Numbers
  1. Public Sub setStatus(ByRef sStatus As String)
  2.     ' Sets the Status Bar Text
  3.     If sStatus = "" Then
  4.         Call SysCmd(acSysCmdClearStatus)
  5.     Else
  6.         Call SysCmd(acSysCmdSetStatus, sStatus)
  7.     End If
  8.     DoEvents
  9. End Sub
No big deal, just thought I would share it.
Mar 8 '17 #4

Post your reply

Sign in to post your reply or Sign up for a free account.