Rod,
Are you suggesting you are inserting multiple values into the same memo field in the same record? If so, have you considered creating multiple records, one for each value?
Duane Hookom MVP
MS Access
________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: desertscroller@cox.net
> Date: Tue, 26 Nov 2013 18:26:07 -0800
> Subject: [MS_AccessPros] Help with updating Memo field
>
>
>
> I am using a tab control with 8 tabs. In each tab control a memo field
> is used to track notes associated with the data contained on the table.
> (Each tab is associated with a table in the database.) I was wanting
> to add new notes to the beginning of the memo field (including a
> datetime stamp and user name). To accomplish this operation I was
> planning on using an unbound textbox for new notes then append to the
> memo field once the focus is lost on the textbox. However, the issue
> is when the user moves to a new tab without taking focus of the textbox
> (lost of focus is not triggered). Is there a way to accomplish both
> operations? If other data (bound to the table) is changed then
> beforeupdate of the bound data is trigger which would allow making the
> changes to the memo field. Any ideas.
> Rod
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar