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?