How to compare 2 similar strings letter by letter and highlight the differences?
- by PowerUser
We have 2 databases that should have matching tables. I have an (In-Production) report that compares these fields and displays them to the user in an MS-Access form (continuous form style) for correction.
This is all well and good except it can be difficult to find the differences. How can I format these fields to bold/italicize/color the differences?
"The lazy dog jumped over a brown
fox."
"The lazy dog jumped over the
brown fox."
(It's easier to see the differences between 2 similiar text fields once they are highlighted in some way)
"The lazy dog jumped over a brown fox."
"The lazy dog jumped over the brown fox. "
Since we're talking about a form in MS Access, I don't have high hopes. But I know I'm not the first person to have this problem. Suggestions?