Validation Rule

[bw]

I want to force the user to enter a period at the end of a note field. Can someone show
me how to do this using a validation rule?

Thanks,
Bernie

 

[Allen Browne]

Not sure why that would matter, but try:
Like "*."

 

[Tim Ferguson]

I want to force the user to enter a period at the end of a note field.

Right(MyNoteField,1) = "." Or Is Null

HTH


Tim F

 

[John Nurick]

In addition to the validation rule you could insert the period by
running code in the BeforeUpdate() event of the textbox displaying the
field. Something like

With Me.ActiveControl
If Right(.Value, 1) <> "." Then
.Value = Trim(.Value) & "."
End If
End With