vba OnChange using if me.text0 ...onchange...then

[MJD1]

hi, trying to use the Onchange in a vba statement but haven't been able to figure it out. I also search but couldn't find the solution. essentially, here's what i'd like to achieve:

if me.text0.onchange = true then

do this..

else

do that

end if


thanks
Martin

 

[MajP]

That is not how you use event properties. I also do not think the on change event is likely what you want. Watch this video about programming with event procedures.

https://www.youtube.com/watch?v=WCHa88rbpzM

My guess you my want to check the controls after update or before update event, not likely the change event. That fires on each keystroke.

 

[dhookom]

MJD1,
You should tell us what you want to accomplish. Something like "when a user presses a key while in a text box name Text0, I want to test the value of .... and do ...."

Duane
Hook'D on Access
MS Access MVP