How to code After Update Event as =NumericOnly([Me]) INSTEAD of =NumericOnly([homePhone])
Posted on 2017-10-12
I have a Form that maintains 10 types phone numbers (homePhone, cellPhone, faxPhone, bestPhone, etc etc)
All 10 boxes are designed to discard non numeric data. (This allows cut and paste of email text like "type 9 then 555 123.2795").
When designing the form I used control click to group all 10 controls, then applied the following properties "one fell swoop".
1) Format tab >Format: (@@@) @@@-@@@@
2) Data tab > Enabled: Yes
3) > Locked:No
4) Event tab> After Update: =numericOnly([Me])
That numericOnly([Me]) did not work. When I ran the form it gave << The object does not contain the automation object 'me' >>
I then tried =NumericOnly([name]) and that failed because it passes the name of the control, not the control itself.
I fixed the problem by changing all 10 textboxes "one by one". For instance =numericOnly([homePhone])
But, I vaguely remember some sort of trick that would allow all 10 events to be set "one fell swoop". Can anybody refresh my memory on this.