Memo field

  • Thread starter Thread starter BG
  • Start date Start date
B

BG

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.
 
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.
Click to expand...

Code the Memo fields Enter Event:
Me![MemoField].SelStart = len(Me![MemoField])
 
-----Original Message-----
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.
Click to expand...

Code the Memo fields Enter Event:
Me![MemoField].SelStart = len(Me![MemoField])
Click to expand...
 
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


-----Original Message-----
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.
Click to expand...

Code the Memo fields Enter Event:
Me![MemoField].SelStart = len(Me![MemoField])
Click to expand...
Click to expand...
 
-----Original Message-----
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.
Click to expand...

Code the Memo fields Enter Event:
Me![MemoField].SelStart = len(Me![MemoField])
Click to expand...
Click to expand...

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.
 
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


-----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])
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top