Results 1 to 6 of 6
  1. #1
    lmarconi is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2020
    Location
    Muscat
    Posts
    17

    Add New Text in a Text Box without allowing any modification of existing text.

    Good afternoon everyone.
    Having a form bounded Text Box where some text might be already present, I was looking a way to allow to add new text but not allow to change what has been already saved in the same field. Is like to freeze what has been already previously saved.
    Is someone so kind to give me a suggestion?
    Thank you,

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,888
    txtBox = txtbox & vbcrLf & txtNewTxt2Add

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,443
    If it is for some sort of chronological notes or comments I strongly suggest you replace it with a subform bound to a new table that stores the record id, comment,(DateCreated,CreatedBy).Much easier to deal with than a huge memo field.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    lmarconi is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2020
    Location
    Muscat
    Posts
    17
    Thank you for kindly suggestions.
    Considering the scope is exactly to keep history of some comments where is good to have a date, I followed the options suggested by Gicu.
    Just another quick question please: having three fields in the new bound subform (ID, ID_DATE and COMMENT), how i can order the view of record by ID_DATE decrescent ? just to have the last comments in the top of the form.
    Thank you again.
    L.

  5. #5
    lmarconi is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2020
    Location
    Muscat
    Posts
    17
    Quote Originally Posted by lmarconi View Post
    Thank you for kindly suggestions.
    Considering the scope is exactly to keep history of some comments where is good to have a date, I followed the options suggested by Gicu.
    Just another quick question please: having three fields in the new bound subform (ID, ID_DATE and COMMENT), how i can order the view of record by ID_DATE decrescent ? just to have the last comments in the top of the form.
    Thank you again.
    L.
    I solved with COMMENT_DATE DESC in the the sub form "ORDERBY" properties.
    Thank you anyway.

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,443
    Glad to hear you solved it Alternatively you could create a query based on your table "SELECT ID, ID_DATE, COMMENT FROM tblComment Order By ID_DATE DESC;" and used that as the record source of the subform.

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Text box not allowing text to be entered
    By jbeets in forum Forms
    Replies: 3
    Last Post: 10-31-2020, 12:05 PM
  2. Use List box to populate text box with existing text
    By Stephenson in forum Programming
    Replies: 5
    Last Post: 10-07-2016, 10:07 PM
  3. Replies: 1
    Last Post: 05-18-2016, 09:46 AM
  4. Replies: 7
    Last Post: 06-05-2015, 11:13 AM
  5. Replies: 3
    Last Post: 02-07-2013, 09:53 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 - Senior Forums