Query search

[Jim]

In my drastic search to solve this issue, I finally found
the problem. All the text is UpperCase in the table, and
I need to type this in when searching. However, is there
a way to type in lowercase and still have the correct
result?

Thanks again,
Jim

 

[John Vinson]

In my drastic search to solve this issue, I finally found
the problem. All the text is UpperCase in the table, and
I need to type this in when searching. However, is there
a way to type in lowercase and still have the correct
result?

If you're certain that the text in the .dbf file will always be upper
case, use a criterion like

UCase([Enter search term:])

 

[Jim]

Thank you John,
I made that change and it works. I will have to make sure
they use the uppercase.

Jim

-----Original Message-----

In my drastic search to solve this issue, I finally found
the problem. All the text is UpperCase in the table, and
I need to type this in when searching. However, is there
a way to type in lowercase and still have the correct
result?

If you're certain that the text in the .dbf file will always be upper
case, use a criterion like

UCase([Enter search term:])



.

 

[John Vinson]

Thank you John,
I made that change and it works. I will have to make sure
they use the uppercase.

If you set up a search form, the user need not be concerned about
case... right??