Label as button doesn't finalize textboxes

krausr79

Registered User.
Local time
Today, 08:51
Joined
Oct 5, 2012
Messages
26
In Access 2007, I'm using labels as buttons because they can be made pretty. Since labels can't have focus, the focus is not shifted from whatever textbox users are in on button press. The value in that textbox is not considered updated when the macro runs, and things get messy from there.

I had been using a setfocus between two textboxes to work around this, but that seems like a copout. I now have a simple form with just a textbox and a button, so this seems like a good time to learn the right way to do this.
 
It's a question. I want to know the official or proper way to finalize the value of a textbox using vba.
 
What would happen if you put a transparent label or text box on top of a button that had no caption?
 

Users who are viewing this thread

Back
Top Bottom