Am I missing something or is this a bug...

[CommanderTed]

I have a FORM with a TEXTBOX defined. This TEXTBOX has had it
Style/Format/Font set to ALL CAPS.

Typing within this field does "display" all CAPS.

The TEXTBOX is used within a Db Result to select only certain record
("like"). Within this Db, all data is UPPERCASE.

Holding the SHIFT key during keying (into the TEXTBOX) DOES pass th
correct UPPERCASE entry to DB Result and it works just fine
However...

Problem: Characters keyed without the SHIFT key, although displayed a
CAPS, is passed to the Db Result as "lower case" resulting in n
match.

Yes, I do know that I can turn on Validate/Data Value to provide a
error message, but that seems to be a bandaid approach.

Have I missed something? Is there a reason why what is DISPLAYED is no
passed?

Thanks

 

[Thomas A. Rowe]

You need to pass the value to the query like so:

LookupValue = UCase(Request.Form("Fieldname"))

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================