Mark A Matte
markamatte at hotmail.com
Tue Apr 8 14:19:54 CDT 2008
Tony, I have found a way to highlight multiple changes in your fields using an OLE embedded word doc. If you would like to share your compare function...I'll add the OLE formatting of the differences. Let me know. Thanks, Mark A. Matte > Date: Sun, 30 Mar 2008 04:41:15 -0800 > From: iggy at nanaimo.ark.com > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Compare Text and Memo fields > > Hey Mark > For simple text or single paragraphs, it highlights the new or updated text. > For memo fields with many paragraphs it highlights new or changed > paragraphs. > For multiple changes (due to limitations with SelectText) I have a > button that states the number of changes and each time the user clicks. > it loops and highlights the next update or addtion. > Two text boxes on the form, one with the new data and one with the old > data, the program highlights changes on either side. > >>Tony, >> >>How does it show in a form the differences? Different font in a text box?? >> >>Thanks, >> >>Mark A. Matte >> >> >> >> >>>Date: Fri, 28 Mar 2008 14:47:35 -0800 >>>From: iggy at nanaimo.ark.com >>>To: accessd at databaseadvisors.com >>>Subject: Re: [AccessD] Compare Text and Memo fields >>> >>>Hey All >>>I have done it and it works perfectly. >>> >>> >>> >>>>Hey All >>>>I have an application that imports ongoing data from EXCEL (each time >>>>its imported it gets put in a temp table). >>>>Before I attempt to do this. >>>>Is there a function available that allows one to compare memo and text >>>>fields (between the temp table and the access table) and pull out the >>>>difference in the text? >>>>I want to be able to indicate to a user if the information has been >>>>changed or updated, and then show them in a form where within the >>>>text, the change has occurred. >>>> >>>>Thanks >>>> >>>> >>>> >>>-- >>>AccessD mailing list >>>AccessD at databaseadvisors.com >>>http://databaseadvisors.com/mailman/listinfo/accessd >>>Website: http://www.databaseadvisors.com >>> >>> >> >>_________________________________________________________________ >>How well do you know your celebrity gossip? >>http://originals.msn.com/thebigdebate?ocid=T002MSN03N0707A >> >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ Pack up or back up–use SkyDrive to transfer files or keep extra copies. Learn how. hthttp://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_packup_042008