I have an access database where one of the fields is named 'mod' and it contains string HEX codes such as AE093C, 00C394, 405FD0 etc.
I am trying to use a data control to do a 'findfirst' on this field but I keep getting the error 3077 'syntax error (missing operator) in expression'
i.e data1.recordset.findfirst("mod='405FD0'")
Other fields with non hex strings work fine using this method. I have also tried using recordsets and sql to search with the same result.
I presume that this is something to do with how the HEX codes are processed. Does anyone have an idea how I might bypass this problem please?
thanks