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
Post a Comment