Solved

Text box: Pressing enter does not go to new record

Posted on 2012-03-14
9
817 Views
Last Modified: 2012-08-13
I have a very simple form (subform) where users enter information into a text box. It is a continuous form so that users can see several records at a time. I had one user call to say that all of the information he entered yesterday is now missing. After I checked into it, all of his data is there. However, when entering the data, he was pressing the enter key and expected it to start a new record. I would have assumed the same. Instead, all of the data has been entered into a single record. Pressing enter simply wrapped the data within the text box. In case it helps, I have attached an image of the subform.subform
0
Comment
Question by:dlogan7
9 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 37722100
check the "Enter Key Behaviour" property of the textbox
make sure it is not set to  "New Line In Field"
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37722119
This is controlled in the properties of the control:
Enter Key behavior:  Default
Will keep you in that field

<However, when entering the data, he was pressing the enter key and expected it to start a new record. >
If the control is the last control in the tab order, sure...
But what if it is the first or third control in the tab order?

Use the Tab to move through the fields.
Use: Ctrl+
...to move to a new record

JeffCoachman
0
 
LVL 15

Expert Comment

by:Ess Kay
ID: 37722268
Add a button for next record
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Closing Comment

by:dlogan7
ID: 37722403
I sure wish that wasn't the default. It seems to me the more common action would be to exit that control. Thanks for the help.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37722976
Again, the origins of this functionality go way back to the days of typewriters and GreenBar paper.

The Enter key has always been the default to move to the next *Line*...
When you press Enter in Excel , you move to the next line/Row
When you press Enter in Word, you move to the next Line
When you press Enter in PowerPoint, you move to the next Line.
When you press Enter in Outlook, you move to the next Line.
When you press Enter in NotePad, you move to the next Line.
When you press Enter in SQL Server, you move to the next Line.
...etc
Why would you want the default in Access to do something that 90% of all application Don't do?

(Because typical Data fields rarely need to wrap, the default enter Key behavior in Access is to stay in the field)

But to be 100% fair, you can change this in the Access Advanced Options:
    Move After Enter: Next Field

But remember Tab has always been the default in most programs to move to the next Field/column
In Excel tab moves you to the next Column
In Excel tab moves you to the next Tab stop of Column in a table.
...etc


Again, Just FYI

JeffCoachman
0
 

Author Comment

by:dlogan7
ID: 37723132
One of the very first things I do with a new computer or new Access software is to change the default Enter key behavior to go to the next record. Maybe that's why I was thrown off. I never experience it doing anything else.

However, I certainly would not expect pressing enter to stay in the same field. I would expect it to either go to the next field in the same record or to the next row...similar to what it does when you're in a table. I can't believe I've never noticed this before.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37723223
OK, did you see how to change this in the Access advanced options...?
0
 

Author Comment

by:dlogan7
ID: 37723329
Sure. That's what I was referring to as the first thing I do.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37723355
ok...
;-)
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question