If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

The second (and the reason I think it may be a carriage return problem) instance when my search function works is when I search for an item which I know was the last item of an uploaded list. ie if I've uploaded a list of three products, when searching for the third item, my function will retrieve it, (no carriage return in it?), but not the first two.

(Not that I can see any carriage returns in my database fields by the way.)

I've tried adding the following into the routine above before anything is added to my database, but it's made no difference.