Writing to StatusBarText

  • Thread starter Thread starter Powderfinger
  • Start date Start date
P

Powderfinger

I asked this before but it seems to have disapeared:
How can I display a message at the botton of the form. I'm trying to set the
StatusBarText but it won't let me.
Me.StatusBarText = "Hi everyone!" <<< doesn't work
 
Powderfinger said:
I asked this before but it seems to have disapeared:
How can I display a message at the botton of the form. I'm trying to set the
StatusBarText but it won't let me.
Me.StatusBarText = "Hi everyone!" <<< doesn't work
Click to expand...


Check VBA Help for the SysCmd function.
 
Hi,
This is the way to display text on the statusbar:
syscmd acSysCmdSetStatus, "Hello"

And with this line you can remove the text:
syscmd acSysCmdClearStatus

But the statusbar is not a part of a form. It is always displayed regardless
of the object you are looking at.
The property StatusBarText applies to a control on a form.
If, for example, you select a textbox on your form and assign a text to this
property, then this text will be displayed on the statusbar when the textbox
has the focus.
 
You could try DoCmd.Echo

I use the follwing to display the number of records during a progress of a
module

If countem / 100 = Int(countem / 100) Then
Dim sttext As String
sttext = "Count = " & countem
DoCmd.Echo False, sttext
End If

Later on I then use DoCmd.Echo True

Allan Murphy
Email: (e-mail address removed)
 
Back
Top