I regularly copy and paste external data into a memo field in my DB. However, this external data always has carriage returns. How can I make it so that AS SOON AS I paste it into the field, the carriage returns are removed?
I'd rather the code run as soon as the text is pasted as opposed to an After_Update event. But I do not know what Event I would use, nor the VBA code necessary.
I think this is the code I need:
Replace([YourFieldNameHere],Chr(13) & Chr(10),""
But I don't know the correct Event. Dirty? Before Update? On Focus?
I'd rather the code run as soon as the text is pasted as opposed to an After_Update event. But I do not know what Event I would use, nor the VBA code necessary.
I think this is the code I need:
Replace([YourFieldNameHere],Chr(13) & Chr(10),""
But I don't know the correct Event. Dirty? Before Update? On Focus?