Writing to StatusBarText

[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

 

[Jeff Boyce]

You got an answer ... forms don't have status bars, applications do.

Have you tried Access HELP?


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Marshall Barton]

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

Check VBA Help for the SysCmd function.

 

[a]

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.

 

[Allan Murphy]

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)