Results 1 to 2 of 2
  1. #1
    SusanCoder is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Mar 2016
    Posts
    30

    enter key behavior - data disappearing from text box when client uses Enter key after entering data

    In the database on Tab B in a subform, all the client sees of the record is the Date field, the label, and the record selector. When the client clicks the record selector (that goes from edit to saved mode) after adding a date in the date field, all is well. But if the client hits the Enter key after typing in the new date, the date disappears and the text box appears to be empty.



    • If the Enter Key Behavior property is set to default, the data disappears from the text box and the record selector automatically goes from edit to saved mode. The data appears in the alternate Tab A/subform, but does not appear in the current form until I exit the main form and open it again.



    • If the Enter Key Behavior property is set to New Line in Field, the data disappears from the text box and the record selector is still in edit mode. When the record selector is clicked (to save mode), the data reappears in the date field and the record appears in the alternate Tab A/subform.


    How do I keep the data from disappearing when the client hits Enter after entering the Date data? Thanks for your advice!

    See more about the project below, in case more information is needed.

    I'm building a subform In Tab B that contains a record consisting of DateOfService (date), UniqueID (number), ServiceType (text), and SpecialistName (text). The client only needs to see the DateOfService field, so the other fields in the record are set to not visible, and ServiceType and SpecialistName have default values set. What is visible on the subform is the DateOfService field and it's label, and the record selector. When the client adds, updates, or deletes a record, event procs fire and the data is updated/deleted on another tab/subform (Tab A), which contains a different view of additional data from in the table. Then the focus comes back to the original subform. All is working, except I discovered this issue when hitting Enter after adding data in the date field. Using Access 2010.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I suspect it's going to a new record. Try changing the Cycle property of the form the textbox is in.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-27-2016, 02:15 PM
  2. Enter Key Behavior
    By jtm013 in forum Forms
    Replies: 8
    Last Post: 12-22-2014, 02:27 PM
  3. Replies: 3
    Last Post: 11-25-2012, 06:09 PM
  4. Replies: 13
    Last Post: 10-04-2012, 04:15 PM
  5. MS Access Enter Key Behavior
    By RAPSR in forum Programming
    Replies: 0
    Last Post: 12-23-2007, 02:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums