CODEWITHSUNDEEP
ms-accesscontrolstextboxms-access-2007vba
Justin
Justin

Reputation: 4539

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

I have a form that is used for data entry, and on one form there is a text box that is used to enter notes. However, if the user hits <ENTER> I need the cursor to stay in that text box and start a new line, but currently it is jumping to the next control (text box).

Is there a simple property setting that would do the trick? Or a VBA method that would accomplish this?

Upvotes: 4

Views: 7185

Answers (2)

HansUp
HansUp

Reputation: 97101

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.

Upvotes: 2

Scott B
Scott B

Reputation: 76

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

Upvotes: 6

Related Questions