Microsoft Access character limit?

I have created a form in Microsoft Access and have a comments text field. I would like to limit this field to a 500 character input. What's the best way to do this?

Microsoft Access character limit?norton antivirus

Use a Memo type field instead of text. The limit is 65,536.

If thats still not enough then go for an OLE object type.

Microsoft Access character limit?security

Just create an "onchange" event for the text box and put this code in it. Change Text0 to match the name of your text field.

Private Sub Text0_Change()

If Len(Me.Text0.Value) %26gt; 500 Then

Me.Text0.Value = Mid(Me.Text0.Value, 0, 500)

End If

End Sub