When Owner's first name ends in an

[DZDS]

There is a field for first name and a field for last name. When the first name ends in an "s", the name should be displayed without an additional "s" after the apostrophe. How would I code this please?

[Rabbit]

Use an IIf function call to check the last letter of the first name before appending the s after the apostrophe.

[nico5038]

I would use:

Me.LastName = Replace(Me.Lastname,"'s","")

So when there's a 's it's is always replaced by nothing.

Nic;o)

[jimatqsi]

That should actually be

Me.FirstName = Me.Firstname & "'s" 
Me.FirstName = Replace(Me.FirstName,"s's","s'")

if the first name is in an object on the screen or report.

DZDS, are you performing this in a query or a form or a report, or some other place? With a little more information we could help you more precisely. If this is enough information, please let us know.

Jim

[zmbd]

Jimatqsi, very nice, reminds me of the old fortran/pascal solution I used on text file string manipulations.

[DZDS]

This is for a report. Thank you.