strip special characters from a subform field during copy and pasting into the subform.
I have a subform named my_data_subform
I have fields
When someone copy and pastes data from an excel sheet,
I need to delete
special characters in case they are bring unwanted characters into the fields.
QTY field nothing but numeric( with no decimals)
my_money = numeric and decimals...but not 1..00 or ..09
description = any alpha/numeric...except special keyboard characters.