I have a Form with an unbound Text control. I would like to limit the data entry to 5 characters as when I move the Control to the database field I wind up with an Error Message if the field is larger than the field defined in my Table . I have tried using CCCCC;;" " as the input mask, which works except when using the DELETE key, a BLANK remains and the rest of the entered characters are not shifted.
eg. Entered: TESST .... use DELETE key .... TES T (space remains)
Is there another way to accomplish this or do I need to test the length of the field via code?