OnClick event in an image control not able to return value in a textbox control on the same form in

[djrivers]

I am not sure what am I doing wrong. In a form, I used to have a command button control with VBA function in it. And one of the procedure is to read the value in a textbox in that same form. It works fine but when I tried to put an image control and put a procedure in its onclick event to read the value of the same textbox, it returns NULL. Am I missing a difference in terms of using the onclick event between a command button control and image control? I'm attaching the file that mimics the issue that I'm having. There's a description there on how to produce the problem.

Thanks,


Darren

[isladogs]

You just need to move the focus away from the textbox and it will then work correctly

Create an after update event for the textbox and add the line
Me.Command8.SetFocus

[djrivers]

Hi Ridders52. Thanks for the reply. That may work. I was just hoping that it will be as easy as coding a command button. It's just weird that it's a same onclick event but reacts differently. Where I'm actually using this method is on a logical statement that checks is the textbox IsNull. I used to have a button where the method was attached then I just decided to us an image instead and that how I discovered the issue. It works fine if you use a button control but not with an image control.

[Missinglinq]

...It's just weird that it's a same onclick event but reacts differently...

It's not the OnClick events that are acting differently! The difference in function, here, is caused because a Command Button can receive Focus...but an Image Control cannot...and until Focus leaves the Textbox... txtTextCopy has no Value.

When you click on the Command Button, Focus is moved away from txtTextCopy...when you click on the Image Control, Focus remains on the Textbox.

Hence Colin's correct suggestion that you need to move Focus away the txtTextCopy before executing the rest of your code that is dependent on its Value.

Linq ;0)>

[djrivers]

Finally, an answer to the mystery that is really not a mystery haha. Thank you so much Missinglinq for clarifying what's actually happening. New learning for me. Thank you too again ridders52 for giving me an idea on how to make it work.

[isladogs]

You're welcome
To avoid confusion, I tend to avoid using images as command buttons especially in forms which contain 'normal images' as well
Are you aware you can include images as well as text on command buttons. For example:

[djrivers]

Are you aware you can include images as well as text on command buttons.

Yup. Although I haven't explored that option much yet.