Remove Fields In an Address Label

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 03 Aug 2005 04:54 GMT

If Have a text box with names and addresses, I would like to remove the
Wifes surname where the Husbands Surname = Wifes Surname

[HusbandFirstName] &" and " & [WifeFirstName]
[HusbandsSurname] & Trim((" "+[WifesSurname]) IIF [HusbandsSurname]=
[WifesSurname])

I realize thats probably a real mess but hopefully it will give you an idea
of what I'm trying to do

Thanks Sean

Reply to this Message

Ron Weiner - 03 Aug 2005 12:29 GMT

Sean, is this what you mean:

IIf([Husbands Surname] = [Wifes Surname], _
[HusbandFirstName] & " and " & [WifeFirstName] & _
" " & [Husbands Surname], _
[HusbandFirstName] &" " & [Husbands Surname] & _
" / " & [WifeFirstName] & " " & [WifesSurname])

Would output
Bill and Mary Smith
Bill Smith / Mary Jones

Ron W
www.WorksRite.com

> If Have a text box with names and addresses, I would like to remove the
> Wifes surname where the Husbands Surname = Wifes Surname
[quoted text clipped - 7 lines]
>
> Thanks Sean

Reply to this Message