Prevent records (rich txt memo) from being duplicated in db

[ppoindexter]

Is there a way to NOT ADD a record, if that record has already been added

the field is a rich text memo field

I have like 2000 lessons to add in a rich text memo field
some are duplicate lessons...i want to be able to add the lesson
in the field and have the db check the lesson (string) and if it is already in the db not allow the new record....it would have to check word for word

i am cutting and pasting the lessons from word documents and have no way to sort before i cut and past

thanks

 

[ed333]

Check out VB help on the "StrComp" function. You can compare 2 strings this way. Then have a messagebox reporting if its a dupe.

Ed

 

[ppoindexter]

thanks
i will give it a try