Copy non-matchable text to another text box

[Only4Access]

Hi Forum,

I have an unbound text box (Text1) with mullti line (Enter Key Behavior: New Line). Users will copy & paste account numbers from notepad. What I am looking for is;

When click on a button,

1. Look all account number copied in Text1 in tblAccounts[TransAccount] (Text Field)
2. If NOT FOUND return those elements in Text2 in multi line.

TransAccount field is NOT set up for storing multi line values. It is a simple TEXT field. Just used text box to enter multiple values at a time.



Thank you for your support.

[June7]

If you have the textbox set for Enter Key Behavior: New Line then this is multiple values in a continuous string. This has been addressed in your other thread. https://www.accessforums.net/forms/s...box-40773.html

Asking the same question in multiple threads is against forum guidelines. I have already deleted one duplicate thread and now this is another.