ms access - How to compare 2 similar strings letter by letter and highlight the differences? -


We have 2 databases that should are matching tables I have an (in-production) report Which compares these fields and displays them in the MS-Access form (continuous form style) for improvement.

All this is well and good, apart from this, difficulties can be difficult to find. How do I format these areas in bold / italic / color differences?

"The lazy dog ​​jumped on a brown fox." "The lazy dog ​​jumped on a brown fox."

(Once they are highlighted in some way, it is easy to see the differences between 2 similar text areas)

"Lazy dog ​​one The brown fox jumped on the brown fox. "
" The lazy dog ​​jumped brown fox "

Since we have a form in MS Access Talking, I have no high expectations but I know that I am not the first person to get this problem. suggestion?


Edit

I've gone with Remou's solution This is not my ideal solution, but it's "very good", especially when I have a rich text option The source table in the query table creates, I used space () to add spacing spacing, so that we can create both fields of the same length. Then I added this code to both areas of the click event (reverse for other fields with text and textb):

  i for integer as i i = 1 to lane ( Me.TextA.Text) If Right (Left Text, A. Well, I), 1) & lt; & Gt; _Wright (left) (Me.TextB.Value, i), 1) Then exit for me.TextA.Selestart = i - 1 Me.TextA.SelLength = Len (Me.TextA.Text) Finish if next I  

The result is that when you click on each field, the "different letters" are first selected at the end of the string. I was able to use it quickly, code and text, so I went with it. But I will review this idea sooner or later because this concept will be useful in many projects.

You can set up a start and session, it will choose a part of the text box. There are some dangers, in which the user can depend on a key and clean the selection.


Comments