How enforce max no of characters in a textbox?

[Guest]

My column bound to the text box is defined as text(50) but I only want the
user to be able to enter 38 characters (This will generate a mailing label
and this is all that will fit on a line). Is there a way to enforce this. I
tried using the Keypress event but it seems to count backspace characters as
characters in calculating the length.

 

[Roger Carlson]

Is there any reason you can't redefine the field to Text(38)?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L