How can I determine if the last character in a text field is plural? 1

[wbwillson]

I have a last name text field and I want to be able to determine if the last name is plural or not so I can add an aprostrophe. For example, if the person's last name is "Doe" then I want access to Change it "Doe's". If the last name is "Simmons" I want it to change to "Simmons'". Any ideas?

Thanks

Bill

 

[KenReay]

Hi

If Right(LastName,1) = "s" Then
LastName = LastName & "'"
Else
LastName = LastName & "'s"
End if

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[wbwillson]

Ken,

Thanks alot! That worked perfectly!

Bill