If Statement

[HeSaidJoe]

I use a filebox to list files from a folder
On click I compare the name of the file to
the name of a file stored in and mdb
If the 2 are the same I delete the file

Problem:
the names from the filebox are all lower case
the names in the mdb are mixed (john, Jonjon,Mary,Larry Hagmagn, etc.)..via user input.

when comparing the names it seems to be case sensetive
as files with upper case characters are not deleted.


Is there a way around this...
can the (If sFilename(FileboxName) = rs!filename then)
be made unCaseSensetive for lack of a better word.
ie..can i accept John = john or John = joHn
as long as each character is equal.
Thanks,

[Iain17]

try converting both values to upper case, or lower case.

e.g

If UCase$(sFilename(FileboxName)) = UCase$(rs!filename) Then
'something
End If

Not sure if this works as i have not tried it on a record set.

Could just throw an Option Compare Text at the top.

[HeSaidJoe]

Thanks...both will work but I'll use the option