How to use a statusbar control in a userform

[Luis M]

Hi everybody

Im using AccessXP and trying to use a statusbar in the userform footer.
However, I don´t know how to show messages on it because I don't find its
Panels and Text properties.

Thanks

Luis

 

[moon]

Hi everybody

Im using AccessXP and trying to use a statusbar in the userform footer.
However, I don´t know how to show messages on it because I don't find its
Panels and Text properties.

Thanks

Luis

In Access 2000 those properties aren't shown either, but they do work.
Just give it a try: UserForm1.StatusBar1.Panels(1).Text = "Ready"

This is also happening to a TreeView or a ListView. No properties are shown
after typing the dot, however those controls can be updated/populated the
same way as in Word or Excel.
I think only the combobox in Access has a real different behavior (callback
function) when it comes on updating it with a dynamic rowsource.

Although I'm still not sure if this will also work for AccessXP, I always
use a bogus form in Word or Excel at the same time, just to test and
checkout the correct syntaxis for those controls.

 

[LuisM]

Hi Moon, sorry too late. But Thank you very much!!!

It really works!!!

Regards.

Luis