If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Memo field
I have a tabbed form to accomodate the different stages
that data is collected during product manufacturing. I want users to have the ability to add comments at anytime in the process so I used the Wizard to add a command button that opens a form for entry into [Comments]. The problem is that after comments are entered once and the command button is clicked to enter additional comments, the user has the ability to delete the previous comments, In fact, by default the text is selected so it makes it very easy to change/delete the previous data. I tried setting ALLOW EDITS to NO and ALLOW ADDITIONS to YES but that doesn't allow additional data. Is there a way this can be accomplished or at the very least place the cursor at the end of text already there? Thanks for the assistance. |
#2
|
|||
|
|||
Memo field
On Fri, 28 May 2004 12:47:11 -0700, BG wrote:
I have a tabbed form to accomodate the different stages that data is collected during product manufacturing. I want users to have the ability to add comments at anytime in the process so I used the Wizard to add a command button that opens a form for entry into [Comments]. The problem is that after comments are entered once and the command button is clicked to enter additional comments, the user has the ability to delete the previous comments, In fact, by default the text is selected so it makes it very easy to change/delete the previous data. I tried setting ALLOW EDITS to NO and ALLOW ADDITIONS to YES but that doesn't allow additional data. Is there a way this can be accomplished or at the very least place the cursor at the end of text already there? Thanks for the assistance. Code the Memo fields Enter Event: Me![MemoField].SelStart = len(Me![MemoField]) -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
Memo field
-----Original Message----- On Fri, 28 May 2004 12:47:11 -0700, BG wrote: I have a tabbed form to accomodate the different stages that data is collected during product manufacturing. I want users to have the ability to add comments at anytime in the process so I used the Wizard to add a command button that opens a form for entry into [Comments]. The problem is that after comments are entered once and the command button is clicked to enter additional comments, the user has the ability to delete the previous comments, In fact, by default the text is selected so it makes it very easy to change/delete the previous data. I tried setting ALLOW EDITS to NO and ALLOW ADDITIONS to YES but that doesn't allow additional data. Is there a way this can be accomplished or at the very least place the cursor at the end of text already there? Thanks for the assistance. Code the Memo fields Enter Event: Me![MemoField].SelStart = len(Me![MemoField]) -- Fred Please only reply to this newsgroup. I do not reply to personal email. ------------------ Thanks Fred. That'll help for now. Do you know if the other option is even possible in Access without significant coding? |
#4
|
|||
|
|||
Memo field
i had the same sort of issue - wanting users to add additional comments in a
memo field, but needing to prevent them from changing/deleting previous comments in the same field. my users don't need to see the previous comments when they're adding new ones, so i solved it by making the control in the form an unbound control and adding a "Save comments" button. when the user clicks it, the underlying code adds the comments to the memo field, as Me!Notes = Me!Notes & " ** " & Me!NewComments Notes is my memo field, and NewComments is my unbound control. hth wrote in message ... -----Original Message----- On Fri, 28 May 2004 12:47:11 -0700, BG wrote: I have a tabbed form to accomodate the different stages that data is collected during product manufacturing. I want users to have the ability to add comments at anytime in the process so I used the Wizard to add a command button that opens a form for entry into [Comments]. The problem is that after comments are entered once and the command button is clicked to enter additional comments, the user has the ability to delete the previous comments, In fact, by default the text is selected so it makes it very easy to change/delete the previous data. I tried setting ALLOW EDITS to NO and ALLOW ADDITIONS to YES but that doesn't allow additional data. Is there a way this can be accomplished or at the very least place the cursor at the end of text already there? Thanks for the assistance. Code the Memo fields Enter Event: Me![MemoField].SelStart = len(Me![MemoField]) -- Fred Please only reply to this newsgroup. I do not reply to personal email. ------------------ Thanks Fred. That'll help for now. Do you know if the other option is even possible in Access without significant coding? |
#5
|
|||
|
|||
Memo field
On Fri, 28 May 2004 14:18:43 -0700,
wrote: -----Original Message----- On Fri, 28 May 2004 12:47:11 -0700, BG wrote: I have a tabbed form to accomodate the different stages that data is collected during product manufacturing. I want users to have the ability to add comments at anytime in the process so I used the Wizard to add a command button that opens a form for entry into [Comments]. The problem is that after comments are entered once and the command button is clicked to enter additional comments, the user has the ability to delete the previous comments, In fact, by default the text is selected so it makes it very easy to change/delete the previous data. I tried setting ALLOW EDITS to NO and ALLOW ADDITIONS to YES but that doesn't allow additional data. Is there a way this can be accomplished or at the very least place the cursor at the end of text already there? Thanks for the assistance. Code the Memo fields Enter Event: Me![MemoField].SelStart = len(Me![MemoField]) -- Fred Please only reply to this newsgroup. I do not reply to personal email. ------------------ Thanks Fred. That'll help for now. Do you know if the other option is even possible in Access without significant coding? If you wish to make the memo field non-changeable, set it's Locked property to Yes. Then, instead of typing directly into the memo field, type into an unbound text control. Set the AfterUpdate event of this control to: [MemoField] = [MemoField] & " " & [ControlName] [ControlName] = "" Once data is in the memo field, it cannot be deleted or altered, however you can add to it at anytime. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#6
|
|||
|
|||
Memo field
Thanks Fred and Tina, I'll try this out.
-----Original Message----- i had the same sort of issue - wanting users to add additional comments in a memo field, but needing to prevent them from changing/deleting previous comments in the same field. my users don't need to see the previous comments when they're adding new ones, so i solved it by making the control in the form an unbound control and adding a "Save comments" button. when the user clicks it, the underlying code adds the comments to the memo field, as Me!Notes = Me!Notes & " ** " & Me!NewComments Notes is my memo field, and NewComments is my unbound control. hth wrote in message ... -----Original Message----- On Fri, 28 May 2004 12:47:11 -0700, BG wrote: I have a tabbed form to accomodate the different stages that data is collected during product manufacturing. I want users to have the ability to add comments at anytime in the process so I used the Wizard to add a command button that opens a form for entry into [Comments]. The problem is that after comments are entered once and the command button is clicked to enter additional comments, the user has the ability to delete the previous comments, In fact, by default the text is selected so it makes it very easy to change/delete the previous data. I tried setting ALLOW EDITS to NO and ALLOW ADDITIONS to YES but that doesn't allow additional data. Is there a way this can be accomplished or at the very least place the cursor at the end of text already there? Thanks for the assistance. Code the Memo fields Enter Event: Me![MemoField].SelStart = len(Me![MemoField]) -- Fred Please only reply to this newsgroup. I do not reply to personal email. ------------------ Thanks Fred. That'll help for now. Do you know if the other option is even possible in Access without significant coding? . |
Thread Tools | |
Display Modes | |
|
|