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
how many of each they
have.
From: Neil Ives neil.i...@gmail.com
To: ms_access@yahoogroups.com
Sent: Mon, July 12, 2010 4:45:30 AM
Subject: Re: [ms_access] Query criteria by upper of lower case
Lonnie,
The way I do this in code is to use 'Ucase' to force
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