Writing information to the Status Bar

Writing information to the Status Bar

If you want to display information to the user using the status bar, then you can use SysCmd to do so:

Dim varStatus As Variant
varStatus=SysCmd(acSyscmdSetStatus,"Message")

And you can clear the status bar by using a different Access constant:

Dim varStatus As Variant
varStatus=SysCmd(acSyscmdClearStatus)

However, there are several problems with using the status bar:

The user might have the status bar turned off;
As Access also uses the status bar to display information, you might find that your text is being overwritten sooner than expected;
There is no guarantee that the user will actually notice anything on the status bar.

A better way would be to use a label on the form, and make it visible when required. You can make the back colour of the label stand out, and use larger font, so that the user will notice it.

Top

Last modified at 06/06/2006 14:54:05