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.

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.

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

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?

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.

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?


.