MS Access Form - Enter key not moving to new line

forms ms-access return carriage-return
JT2013 picture JT2013 · Jul 15, 2013 · Viewed 24.3k times · Source

I have an odd issue with a form I have in MS Access. For some reason, when I hit the "enter" key within a text box, the cursor moves to a different text box. What i am looking to happen is for the cursor to simply move to another line within the same text box.

Anyone have any ideas how to correct this?

Answer

HansUp picture HansUp · Jul 15, 2013

You can use Ctrl+Enter to enter a new line into any text box.

For a specific text box, you can make the Enter insert a new line instead of moving to another control on the form by changing the text box's Enter Key Behavior property.

text box Enter Key Behavior property

That's what I think you're actually looking for, but you would need to set that property for every text box where you want it to happen ... which may be fine for your needs. I mentioned Ctrl+Enter first only because that method works for any text box without changing the default property setting.

Related questions

How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?

I have a combo box which is of a lookup type, i.e., I've selected the source to be a column from a table and am storing the selected value in another table. The table which I am looking up …

Read More
Adding a file browser button to a MS Access form

I'd like to add a "Browse" button to an MS Access 2007 form that will bring up a standard Windows file browser (as a modal window) and allow the user to select a directory. When the user OKs out of that …

Read More
Add "All" option to ComboBox used to filter for report in MS Access

I'm trying to follow Microsoft's example on how to add an "All" option to a ComboBox in Microsoft Access, but their article does not do an adequate job of providing guidance, aside from specifying the code. What I'm trying to …

Read More