length validation

[butter30]

in access 2007 does anyone know to build an expression for length validation, from the expression builder that states that minimum length of 3 characters is required.

 

[vbaInet]

This is how I handle it on the Change event of the control (in this instance, a text box):

    If Len(txtbox1.Text) > 3 Then
        txtbox1.Text = Mid(txtbox1.Text, 1, 3)
        txtbox1.SelStart = 3
    End If

Unless someone has another idea for you.

 

[vbaInet]

This is how I handle it on the Change event of the control (in this instance, a text box):

    If Len(txtbox1.Text) > 3 Then
        txtbox1.Text = Mid(txtbox1.Text, 1, 3)
        txtbox1.SelStart = 3
    End If

Unless someone has another idea for you.

Ignore that completely. I thought you meant maximum.
Are you referring to tables or forms?

 

[butter30]

i was referring to table although both would be useful

 

[vbaInet]

Try this:

Len([FieldName]) >= 3