Status Bar Text Problem--Help!

[Brian Smith]

I asked about this in the forms coding NG and didn't receive a response so
I'm going to try here. If I'm asking in the wrong places I'd appreciate
knowing.

Anyway, I have a number of forms which have status bar text assigned to the
controls. Everything seemed to be working fine but now I'm noticing a very
strange problem. I have created a switchboard type form that has command
buttons on it--there is a button to open each of the forms that I want to be
able to open from this form. The forms open up with no problems (basically
used the Wizard to generate the code) but instead of seeing the status bar
text I assigned to the controls I see 'Ready.' If I go into design view and
then back into form view without changing a thing, everything works as it
should. Also, if I open one of the forms directly from the database window
everything works as it should.

Does anyone have any idea of what the problem could be or an easy way to get
rid of 'Ready' and replace it with the status bar text I have assigned to
the control? I've searched Google and Microsoft's Knowledgebase and cannot
find anything that seems to discuss this problem.

Thanks in advance for any insight to this problem. It will be greatly
appreciated.

Brian

 

[John Spencer (MVP)]

Does the button have the focus when you see the word "Ready" or does the form
have the focus?

You probably click on the button and the button gets the focus, but then
immediately does an action.

Try right-clicking on the button, or navigating to the button(s) using the tab
key and see if your status bar text behaves as you expect. Or try Clicking on
the button and while keeping the mouse button depressed move off to the side.

If that doesn't solve the problem, then post back.

 

[Brian Smith]

John, I think I need to explain this a bit more clearly based on your
response. The switchboard-type form isn't the issue. It's the forms that are
being opened up from it. No matter what type of control has the focus I see
"Ready" in the status bar instead of the text that I have assigned to Status
Bar Text. Yet, if I open up these forms directly from the database window
the status bar text shows up as it should. Same thing happens if I open up
one of these forms from the switchboard, go into design view and then back
to forms view. In other words, things work. Clearly something bizarre is
happening when I open up these forms from the switchboard form. I'm
completely stumped at why this behavior is occurring because this is such a
basic action.

If you need any more info let me know.

Thanks.

Brian

 

[John Spencer (MVP)]

Don't need any more info. AND unfortunately, I don't have an explanation.

When I get these kinds of strange behavior I often do a compact and repair, a
decompile, and another compact and repair. If that fails and I've got a recent
backup, I usually revert to the backup and rebuild the stuff I've added. If no,
backup I open a blank database and import all the objects except the one giving
me trouble.

I don't have to do this often, but every once in while. Usually it's my own
fault for forgetting and doing something stupid like editing vba code on a form
while the form is running... DUMB IDEA, it often works but when it fails I end
up with a corrupted database with strange behavior.

Sorry, I don't have a solution.