Should on element exit programming NOT execute in a tableview subform?

Quote:

I thought so also. I have the initial caps function (MultInitCaps())in the on element
Exit and if I use formview it works - if I use tableview it does not.

Now that you confirmed it should work, I will play and see what I did to break it.

Quote:


I am looking forward to seeing you all also. I can not wait to learn new techniques and re-enforce techniques I have been previously taught to improve my applications.


I am always amazed at how much knowledge Erika can share and teach in her classes. I always leave the classes with much more useful knowledge then I planned on getting. All this and now its taught in a historic 1860's brick building. How cool is that!!

Robert,
Table is not setting the "ThisElement" construct. The code is being called, but because you are using "ThisElement" no value is being set. I'm looking into it. In the meantime, turn your subroutine into a function and pass the value of the LE "Address" into your function "MultInitCaps" and then have "MultInitCaps" return the result to the caller.

Address On Exit:

Address = MultInitCaps(Address)
 

GLOBAL CODE:

Function MultInitCaps(vValue as string)
  // Do stuff to vValue here
  return vValue
End Function
 

That way you have a workaround that is no less generic.