Results 1 to 13 of 13
  1. #1
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Problem editing Memo field in a subform because if display won't persist after new character


    Windows 7/Access 2007

    When the Memo data in the field extends beyond the box, the scroll bar or arrow keys must be used to move to the end of field to append new data. When a character is entered, it is recorded but the display shifts away from the part being edited. Additional characters may be blindly entered while the display is focused elsewhere.
    The text box is in a sub-form.
    TIA for any ideas or suggestions.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Not sure what you mean by 'display shifts away from the part being edited'.

    When I move into textbox bound to memo field, the cursor is positioned at end of text and I just start typing.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481
    When I move to the textbox, I can only see the first portion of the record. The cursor may be positioned at the end, but I can't see it. I have to use the scroll bar and/or the arrow keys to get to the end of the record. As soon as I type the first character to be appended, the display reverts to its earlier position. Thus, if I continue to type, the characters won't be displayed unless I scroll back down again.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I actually have scroll bar disabled. So I just tested with it enabled. No difference. I cannot replicate this issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481
    OK, why is my cursor is not positioned and displayed at the end of the record when I click on the field or scrollbar...
    Whether the record is fully displayed or not, it is not working.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Can't replicate the issue so can't determine solution. If you want to provide your db for analysis, follow instructions at bottom of my post.

    Wait, do you mean end of the text in the textbox?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481
    If the stored notes don't run beyond the limits of the text box, I can click at the end of the displayed text and edit as expected. However, if the text (record) extends beyond the limits of the text box, then I have to scroll and/or use the arrow keys to position the cursor at the end of the text (and record) and be able to see the end of the text. When I type to append, the cursor apparently stays at the end of the record, but the display shifts and displays the first part of the record. You can type and add characters, but you can't see it unless you scroll/arrow keys again.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    That does not happen to me.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Will try to provide DB. Thanks for looking.

  10. #10
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Database too big after stripping data to a minimum.

    2.2 MB
    Maybe take out reports?

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    2mb zip allowed.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  12. #12
    hertfordkc is offline 18 year novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Here is the DB

    See the included Readme.


    zipaccess.zip

  13. #13
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Consider organizing the subforms on a tab control.

    Did some more experimenting with my db. When I click into textbox, the cursor is actually positioned where I click but the text automatically scrolls up to show the end, even if the click is on the first character, I do have to click again (or use cursor keys) to position cursor at the end but at least I can see the end.

    I looked at memo textboxes in another db. In that one, the text does not scroll up. I can't get them to act like my other db. This really has me baffled. I don't know why they behave differently nor why yours has even another different behavior.

    Could try code to position cursor at end of text. I use SelStart, example:

    Private Sub cbxSample_Enter()
    If Not IsNull(Me.cbxSample) Then Me.cbxSample.SelStart = Len(Me.cbxSample)
    Me.cbxSample.Dropdown
    End Sub
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Problem editing Memo field in a subform
    By hertfordkc in forum Forms
    Replies: 2
    Last Post: 11-04-2014, 04:12 PM
  2. Replies: 1
    Last Post: 11-26-2013, 06:40 PM
  3. Memo field 'white box' to display on Report
    By noaccessguru in forum Reports
    Replies: 8
    Last Post: 09-02-2013, 12:21 AM
  4. Excel Import field truncation problem (to Access Memo field)
    By jhrBanker in forum Import/Export Data
    Replies: 6
    Last Post: 07-27-2012, 08:52 AM
  5. memo field problem
    By gustavopalminha in forum Programming
    Replies: 4
    Last Post: 05-07-2012, 08:33 AM

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