Reading first line of textbox Updating in AfterUpdate

[Lumpierbritches]

Thank you in advance for any and all assistance, it is GREATLY appreciated. I
was wondering if there is a way to tell Access 97 to compare the first line
with other textboxes using the "Trim(StrConv" and joining two textboxes into
one then adding it, ONLY if that string IS NOT matched in another textbox?

Example: Trim(StrConv(LastName,1))& " " &Trim(StrConv(FirstName,1)) then adding
this to the address textbox, only if line one evaluated false to append the
name to the address in the AfterUpdate in the Address?

So, the Address would read before update:

1234 Any Street
AnyTown, USA 12345

and AfterUpdate would read

ANY PERSON
1234 ANY STREET
ANYTOWN, USA 12345

thank you,

Michael

[Wayne Morgan]

Something like

If InStr(Nz(Me.txtTextbox2,""), Nz(Me.txtTextbox1,"")) = 0 Then

This will be true if the string from txtTextbox1 is NOT in txtTextbox2.

--
Wayne Morgan
MS Access MVP
"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m10.aol.com...

Thank you in advance for any and all assistance, it is GREATLY appreciated. I was wondering if there is a way to tell Access 97 to compare the first line with other textboxes using the "Trim(StrConv" and joining two textboxes into one then adding it, ONLY if that string IS NOT matched in another textbox?

Example: Trim(StrConv(LastName,1))& " " &Trim(StrConv(FirstName,1)) then adding this to the address textbox, only if line one evaluated false to append the name to the address in the AfterUpdate in the Address?

So, the Address would read before update:

1234 Any Street
AnyTown, USA 12345

and AfterUpdate would read

ANY PERSON
1234 ANY STREET
ANYTOWN, USA 12345

thank you,

Michael