DLOOKUP where TEXTFIELD > SEARCHSTRING

[Whizbang]

I would like to compare two string values in a DLOOKUP to find a record where the text in the field is greater than the SearchString entered (eg "XYZ" is greater than "ABC").

If I just do a simple string comparison in a textbox with Control Source of ="XYZ" > "ABC" it returns -1 (or TRUE). But when I try the same in a DLOOKUP, I get an error. I assume this is because DLOOKUP does not allow for string comparisons in this way.

So, how would I lookup that finds the first text value greater than another text value?

[boblarson]

Your statement is a bit confusing. First off post an example of the field in question. And post the purpose of this exercise. What is it you are really trying to do? I know you have stated something but it doesn't explain fully.