MS Access 2007 - a property for a text field that allows the end user to press Enter to return, and not the next

I have a form that is used to enter data, and in one form there is a text field that is used to enter notes. However, if the user presses <ENTER> , I need the cursor to remain in this text box and start a new line, but currently it is moving on to the next control (text box).

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

+4
source share
2 answers

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

+6
source

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

Another option would be for users to enter CTRL + Enter to insert a string into a text control. However, your users may not go for it.

+2
source

Source: https://habr.com/ru/post/1311084/


All Articles