Limit Characters allowed in a Memo Field

[TechyGal]

Hi there,

I really hope someone can help as I have been trying for two days now and to no avail.

I am trying to add a validation rule to a memo type field in MS Access 2007. I need to limit the amount of text that can be entered into this field to about 1000 characters. I have tried using the following validation command but it is not working! Any ideas would be very greatfully recieved! :)

Validation Rule =Len("Specification")<1000

where "Specification" is the name of the memo field I need to limit.

PLEASE HELP ME!!

Thanks, TechyGal

[missinglinq]

And what do you want to do when the limit is reached? Simply use the first 1000 characters, throw up a message telling the user the data is being truncated to 1000 characters, something else?

This will do both:

Private Sub MyMemoField_Change()
Dim CharCount As Integer
 
If Not IsNull(Len(MyMemoField)) Then
 CharCount = Len(MyMemoField.Text)
  If CharCount > 1000 Then
   MsgBox "You've reached the limit"
   Me.MyMemoField = Left(Me.MyMemoField.Text, 1000)
  End If
End If
End Sub
 

Welcome to TheScripts!

Linq ;0)>

[MGrowneyARSI]

Take a look at this site some in the past was trying to do the same thing and said this put him in the right direction looks a bit more complex then you wouild think http://www.allenbrowne.com/ser-34.html hope that helps

[missinglinq]

MGrowneyARSI, just FYI, when posting links you need to use the URL tags, such as here:

[ URL ]http://www.allenbrowne.com/ser-34.html[ /URL ]

but eliminating the spaces inside of the square brackets.

Linq ;0)>

[MGrowneyARSI]

Sure thing will do next time

[FishVal]

Hi, TechyGal

Len("Specification") always returns 13, the length of word "Specification". ;)
Use square brackets to enclose field name. Len([Specification])<1000

Good luck.