compare two text strings

[44nato44]

Hi

I would like to compare two text strings and write the differences.

Is this possible?

Thanks

Best Regards

Torben

 

[alvechurchdata]

It depends what you mean by "compare".

Do you want to detect that :
"fred" and "freda" share the same four letters,
"red" is like "fred" without the first letter,
"feared" is like "fred" with an extra "e" and "a",
"fee" is like "fred" with an "r" missing and an "e" added.

Or even that "colin" is like "fred" but missing the "f", "r", "e" and "d" and with an extra "c", "o", "l", "i" and "n"?

Perhaps these examples sound silly but they are all different ways of comparing strings.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[44nato44]

Good points.. basically I have a memo field, which users can change... So what I am looking for is is this difference between the old set of text and the new.

Not sure if there is an easy way of doing that ?

 

[alvechurchdata]

Easiest way is to catch them as they change it. Get the value of the memo field as the record becomes current and see if it has changed when the record updates. If the memo field is called "notes" then something like this:

Private mstrNotes as String

Private Sub Form_Current()
  mstrNotes = Me.notes.Value
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)
  If Me.notes.Value = mstrNotes Then
    '-- Nothing's changed
  Else
    '-- Something has changed. 
  End If
End Sub

Geoff Franklin

http://www.alvechurchdata.co.uk