Memo field punctuation

[bdhtexas]

I have a form set up where user's type in an explanation of how a claim is being appealed and resolved in a memo field.

One problem, for some reason management doesn't want these explanations to end with a period. But the users keep ignoring our request and keep using the period.

Is there a way that you can code this memo field to where it will allow punctuation throughout, except at the end?

 

[WayneRyan]

bhd,

Use the AfterUpdate event of the field:

If Right(Me.YourMemo, 1) = "." Then
   Me.YourMemo = Mid(Me.YourMemo, 1, Len(Me.YourMemo) - 1)
End If

Wayne