I'm looking for an right approach to both limit and alter the text being typed in a textbox column?
For the given cell column, I'd need to limit the user input to a range of characters (A-E,0-9), but also auto-uppercase the values as they are being typed in? I've also tried to split the validation and uppercase portions in two separate events, but the real-time uppercase always seems to get me stuck.
I've looked at ValueChanging, as its raised for each keystroke, but changing the cell value within this event causes a stackoverflow, and changing the e.NewValue does not have any effect.
I've also tried CellFormatting - but that only formats the text after the edit is completed.
For the given cell column, I'd need to limit the user input to a range of characters (A-E,0-9), but also auto-uppercase the values as they are being typed in? I've also tried to split the validation and uppercase portions in two separate events, but the real-time uppercase always seems to get me stuck.
I've looked at ValueChanging, as its raised for each keystroke, but changing the cell value within this event causes a stackoverflow, and changing the e.NewValue does not have any effect.
I've also tried CellFormatting - but that only formats the text after the edit is completed.
Thoughts?