Memo field duplicate nightmare!

[Guest]

Hi,

I have a table to store comments input by users. Due to the size of the
comments, I have had to use a Memo field type.

For some reason, the comments are sometimes duplicated in the table. I want
to remove these duplicates, but cannot correctly identify them because of the
Memo field type. (I want to check Unique_ID, Date/Time Posted and Comments)

I also have trouble sorting using the Memo field.

Is there any other way of doing this?

Cheers,
Steve

 

[[MVP] S.Clark]

If I were a gambling man, and I am, I'd bet that the user's are entering the
dups, without knowing they are.

How it works is that they enter some text, then press the enter key, which
for a memo field, the text box will default the behavior to "Add new line".
So, the user thinks the field magically went blank, so they type the same
text again, and then click out of the text box control.

Just a theory, so feel free to provide other pertinant data such as how the
users are performing data entry. Directly to table, via a form, etc.

 

[Guest]

Ok,

The comments are input from a Combo box on a form.

The user can select 'Standard text' from the drop down or input their own
comments.

Another annoying thing about Memo fields is they can't be sorted, or dont
show up in the Query Wizards (e.g. Duplicate query) as an available field!

I have found if I use Left([Memo Field],255) it then makes it an 'available'
field, but I do actually need the whole field.

I hope this makes sense! (it is monday morning)

Steve.