I have an Access table which has an indexed field with No Duplicates
set.
Prior to adding a new record I compare the string to be inserted with
those already in the table. After the first incidence of a string is
inserted subsequent duplicates should be eliminated before reaching
the code that inserts them into the table.

I run into a problem with a string that contains a comma. A subsequent
duplicate is not being picked up and Access itself throws an error
when it detects the duplication.

String comparison methods I have tried are:

rstRecordSet.Fields(0) = Listing3(0).List(i)
and
cmp = StrComp(rstRecordSet.Fields(0), Listing3(0).List(i))

I would be grateful for a solution to this problem

Nod

Archived from group: microsoft>public>vb>syntax