I have a text control in a user form which I want to be multi-line (MultiLine = TRUE) , so that as the user types many characters, text will wrap within the control. I do NOT want the ENTER key to move focus to the next control in the Tab Order. But I also do not want ENTER to create a new line withint the control; everything must be in a single paragraph.
I have tried using the KeyPress event to trap ASCII 10 or 13 and then set KeyAscii = 0. This is what I use to suppress certain characters or to substitute one character for another. ENTER doesn't seem to get trapped. Any suggestions on how I can handle this? I suppose I could allow the CRs, and convert them to spaces later on, but I'd prefer to have the user be aware at the time.