ALL CAPS

[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

 

[Rick Brandt]

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?

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?])

 

[Doug]

Thanks

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?

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?])

 

[John Vinson]

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?

ummm... why? Access searches are case-insensitive.

 

[John Spencer (MVP)]

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.

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?

ummm... why? Access searches are case-insensitive.

 

[Rick Brandt]

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.

That is what I assumed as well. I work against UDB for the AS400 quite a
bit in Access and it is case-sensitive.

 

[John Vinson]

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

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.