Results 1 to 5 of 5
  1. #1
    Roncc is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2017
    Posts
    85

    Memo field questioin; how can I get the cursor to move to the next line on enter?

    I have a memo field that I would like to use for ongoing notes. When I enter data into the field and hit the Enter key, the entire text is highlighted and, upon entering new (continuing) data, erases what I have just written. I want the end users to be able to keep ongoing notes on a client and I don't want to confuse them. Is there anyway to "tell" the cursor to move to the "next line" when I hit "Enter"?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Assuming you are displaying the field in a control on a form, have you looked at the "Other" tab of the properties sheet for that control?

  3. #3
    Roncc is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2017
    Posts
    85
    That solved it. I should have looked there first. Thanks so much RuralGuy (and to everyone in the forum) for your patience.

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,407
    Create a "dummy" textbox, named txtDummy. Make is zero tall and zero wide. In the after_update event for the memo field:
    Code:
    txtDummy.SetFocus

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're very welcome. I marked this thread as Solved for you.

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

Similar Threads

  1. Line change within memo field
    By anitasavio in forum Database Design
    Replies: 4
    Last Post: 03-21-2016, 07:36 PM
  2. Replies: 2
    Last Post: 02-08-2014, 07:10 PM
  3. Replies: 2
    Last Post: 11-19-2013, 04:35 PM
  4. Field auto enter new line on enter event
    By Ruegen in forum Forms
    Replies: 3
    Last Post: 09-17-2013, 09:00 PM
  5. Replies: 12
    Last Post: 03-03-2013, 07:13 PM

Tags for this Thread

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