Limiting a text box size
- Thread starter yhgtbfk
- Start date
You have several alternatives:
(1) Test the length of what's been entered with the Len function. You'll get an error for inputting more characters in the field.
(2) Use the KeyPress event to count the characteres entered, character by character.
(3) Use the Validation Rule property for the field in the underlying table.
(4) Use the Validation Rule property for the form field.
(1) Test the length of what's been entered with the Len function. You'll get an error for inputting more characters in the field.
(2) Use the KeyPress event to count the characteres entered, character by character.
(3) Use the Validation Rule property for the field in the underlying table.
(4) Use the Validation Rule property for the form field.
llkhoutx said:
Thank you very much. I might try the first two.
But....
By length I didnt mean character length. I meant as in:
If I set the length to be 5cm, when the user types in it, they cant type more than 5cm worth of characters.
Normally as you type beyond the length of the text box, you can still type, and just see the last bit of what you typed.
What I want to do is limit the text box so once you hit 5cm, nothing more can be typed.
If this is too hard, I will estimate how many characters can fit in the box (by typing all 0s or Ws) and then limit the length to that
R
Rich
Guest
Set the field size to limit the number of characters that can be typed into the text box
