Well done, you've come a long way on this already. Can you provide an example string that that demonstrates the problem with de-duplicating? I thought it might be how you handle the start or end of a run but couldn't replicate it with anything obvious.

As I mentioned in the first post, a recordset is an alternative way of doing this and this would allow you to make use of the SQL SELECT DISTINCT query to remove any duplicates without stepping.

I will try to find some time later today to have a closer look at the code to see if there is anything to fix.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia