MS Access 2007 - Property for text box to allow end-user to hit enter for return, not next

Question

So I have a form that user's use for data entry, and on one form there is a text box there that is basically used. To enter notes. However, if the user hits i need the cursor to stay in that text box, and start a new line (uh....like word would)....but currently it is jumping to the next control (text box).

So is there a simple property setting that would do the trick? Or a VBA method to accomplish?

Thanks Justin

Answer 1

In Ac2003, there is the "Enter Key Behaviour" property, which gets set to "New Line in Field".

Answer 2

I suspect Scott's answer is what you're looking for. That property is available in Access 2007 also.

Another option would be to have the users enter CTRL+Enter to insert a line into the text control. Your users may not go for it, though.