Filter data entry on DataGrid Form

[trevix]

I am having some problem on filtering the user input keys for a Datagrid Form.
This, on the script of the editable field of the row template, does not intercept the keydown.

Code: Select all

on keyDown inKey
     if inkey is not in "0123456789abcdefghijklmnopqrstuvwxyz" OR the number of chars of me > 16 then
          beep
     else
          pass keyDown
     end if
end keyDown

One way to do it would be to put the script on the DG group.
But how do I refer to the field, in order to calculate how many chars have been inserted?
Is there a way?
Thanks

[Klaus]

Buongiorno Trevix,

use THE TARGET!

Code: Select all

on keyDown inKey
   if inkey is not in "0123456789abcdefghijklmnopqrstuvwxyz" OR the number of chars of the target > 16 then
      beep
   else
      pass keyDown
   end if
end keyDown

Tested and works!


Best

Klaus

[trevix]

Thanks.
I also added this, otherwise "@" can be keyed on OSX:

Code: Select all

On OptionKeyDown then
     Beep
end OptionKeyDown

[dunbarx]

Just so you know, the fields in a DG are named:

Code: Select all

"Col 1 0001", "Col 2 0001",...
"Col 1 0002", "Col 2 0002",...

I have found it useful now and then to reference DG fields directly.

Craig