By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,889 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,889 IT Pros & Developers. It's quick & easy.

Reading first line of textbox Updating in AfterUpdate

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.