ALL CAPS

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I am using Access 97. When I use [Which Type?] in the criteria for the
query I get a msg box that asks for that input. Is there a quick way to make
the input all caps?
Thanks
Doug
 
Doug said:
I am using Access 97. When I use [Which Type?] in the criteria for the
query I get a msg box that asks for that input. Is there a quick way to make
the input all caps?
Click to expand...

You can't make the user type all caps, but you can make it so that is what the
query sees as criteria.

Instead of just [Which Type?] use..

UCase([Which Type?])
 
Thanks
Rick Brandt said:
Doug said:
I am using Access 97. When I use [Which Type?] in the criteria for the
query I get a msg box that asks for that input. Is there a quick way to make
the input all caps?
Click to expand...

You can't make the user type all caps, but you can make it so that is what the
query sees as criteria.

Instead of just [Which Type?] use..

UCase([Which Type?])
Click to expand...
 
I am using Access 97. When I use [Which Type?] in the criteria for the
query I get a msg box that asks for that input. Is there a quick way to make
the input all caps?
Click to expand...

ummm... why? Access searches are case-insensitive.
 
The only reason I can think of is that the OP is searching an attached file of
some type. I seem to recall that some of the ISAMs (perhaps EXCEL) are case
sensitive.

Just tested this with Linked Excel table and Access 97 and found that criteria
of Like "John*" returned three records and Like "john*" returned no records.
Also got similar results with John Spencer versus John spencer.

I wonder what happens with a linked text file? Had to test it. Same results.

John said:
I am using Access 97. When I use [Which Type?] in the criteria for the
query I get a msg box that asks for that input. Is there a quick way to make
the input all caps?
Click to expand...

ummm... why? Access searches are case-insensitive.
Click to expand...
 
John Spencer (MVP) said:
The only reason I can think of is that the OP is searching an attached file of
some type. I seem to recall that some of the ISAMs (perhaps EXCEL) are case
sensitive.
Click to expand...

That is what I assumed as well. I work against UDB for the AS400 quite a
bit in Access and it is case-sensitive.
 
The only reason I can think of is that the OP is searching an attached file of
some type. I seem to recall that some of the ISAMs (perhaps EXCEL) are case
sensitive.

Just tested this with Linked Excel table and Access 97 and found that criteria
of Like "John*" returned three records and Like "john*" returned no records.
Also got similar results with John Spencer versus John spencer.

I wonder what happens with a linked text file? Had to test it. Sa
Click to expand...

Yipes! Thanks, John; I wasn't aware of that issue. I knew that Oracle
and (under some circumstances) SQL backends had this problem but
didn't realize it was a wider issue.
 
Back
Top