Where to put edits in an editable Flex Grid

[swade61970]

I have an editable Flex Grid with several columns. I want to put logic in the program to keep the user from entering alpha chars in some of the columns. I want the program to not accept alpha chars from the keyboard. So where do I put the logic in to send the backspace when this happens?

 

[lone84]

Hi,

You can try to use the isnumeric function

 

[johnwm]

I'd use the KeyPress event and just do a Select Case on KeyAscii:

Select Case KeyAscii
Case 8, 46, 48 To 57 ' allows BS, Dec point and numbers only
Exit Sub
Case Else
KeyAscii = 0
Beep
End Select


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'