Or you can use the KeyDown event to capture the keystrokes and, by using the
Len() function you can test for the length and then cancel any other
keystrokes if the length has been reached.

For example:

Private Sub MyTextBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
If Len(Me.MyTextBoxName.Text) = 6 Then
KeyCode = 0
Msgbox "Only 6 characters allowed!", vbExclamation,"Max Length
Reached"
End If
End Sub

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________


"-Obama" wrote:

Thanks, Can I do it in a form level?


"Jeanette Cunningham" wrote in message
...
-Obama,
you could do this in the table by adjusting the Field Size property for
that
field if it is a text field.

For a number field you could write a validation rule for the table like
this:
For a field called MyNbrTest
Validation rule: Len([MyNbrTest])7
Validation text: No more than 6 digits allowed

Jeanette Cunningham

" -Obama" wrote in message
...
I am using access 97. How do I limit the number of character of a control
in a form at form level? Thanks.