Distinguish 0 and O's in a string

[mhifd009]

I have a user input where i do a dlookup in a table-->field but there is a need to find the string even if the original field value contains 0 or O and also if the user input contains 0 or O.

ie - CODE1234 (entered with a numeric 0) should find CODE1234 when entered with a Alph 0)

[ADezii]

I have a user input where i do a dlookup in a table-->field but there is a need to find the string even if the original field value contains 0 or O and also if the user input contains 0 or O.

ie - CODE1234 (entered with a numeric 0) should find CODE1234 when entered with a Alph 0)

'Before using the DLookup() Function, you can replace all occurrances of
'the SubString "C0de" with 'Code" as in the example:

Dim retString As String
 
retString = Replace("jjhyuC0de1234", "C0de", "Code")
Debug.Print retString

retString will now return "jjhyuCode1234" so it can effectively be used with
DLookup() to return the proper result

[Killer42]

Quick question - what about other visually similar characters such as 1 (one) and l (lowercase "L")?

And one for the experts - can regular expressions be used in Access? Seems as though they might fit the bill for this kind of thing.

[mhifd009]

Absolutely correct, have now used nested repace() to solve problem for (0's o's) (l's 1's) - thanks.