Lonnie, The way I do this in code is to use 'Ucase' to force the string into uppercase when checking against the same string in upper case:
If Ucase(Mystring) = "ACTUALS" then [do something] Alternativeley you could convert all user input into upper case when first entered. In Access the data tables and forms can be set to force input into Upper case. Neil Ives On 11 July 2010 23:51, Lonnie Johnson <[email protected]> wrote: > Just curious, > > Is there a way to search or match a string that is just upper case or mixed > case? I have a filed that has these two values and the customer actually wants > to be able search for just one of the two. The two values are... > > 2010 ACTUALS > > 2010 Actuals > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > Yahoo! Groups Links > > > > -- Neil Ives
