hey Arnold
1) You don't need the "IF 1=1" part in the rules, since you want it to happen all the time
data=upper(data) no IF
just remember that for future use in any rule
2) if you modify your rules to Dynamic, and Don't execute on Server, then let the user type what they want, and when they tab off, it will change.
No need to the Style/CSS rules.
2a) The Dynamic checkbox makes it happen when they tab off
2b) The Dont X on Server keeps the rules engine from firing it all the time on the backend
2c) Since you've handled it now at data entry, You & Aware never needs to worry about it again.
2d) In THIS case, no need for extra checking (IF x IS NEW, or IF x WAS CHANGED) - just let the Dynamic part happen
3) In my experience, you'll never have any issue with mixed case in EMail addresses - no need to touch that
Someone else may have some suggestions - I generally don't worry about these issues at all.
MS SQL isn't going to care - I have mine set to ignore case for searching.
So a user can filter on "Arn" or "arn" and get the same result in a grid.
jaymer...
