473,320 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do I find the text which is entered in UPPER CASE

1
Using Access, I need to identify which records in my database are entered in UPPER CASE.

I don't want to convert to lower case. I simply need to know which records need have this problem.

Thanks

CathyL
Mar 10 '10 #1
2 4984
TheSmileyCoder
2,322 Expert Mod 2GB
I don't know if there is a native SQL way of doing this, but try adding this as a field to your normal select Query

Expand|Select|Wrap|Line Numbers
  1. expr1: StrComp([tx_Main];UCase([tx_Main]);0)=0
And then add as a criteria that this field must be true.

Simply replace tx_Main with the name of the field you want to check for Uppercase.

If your having trouble making it work, try to poste your normal SQL select query here, and I can help you adept it.

Explanation:
StrComp will compare the first and second argument, and return 0 if they are equal to each other. (which is why I added the =0 to the end)
The 3rd argument passed to strCompare is a 0, telling strCompare to use binary comparison (in which "a" not equal "A"), as composed to Textual comparsion (in which "a"="A").

The Ucase converts the field to upper case. So the logic is that if the Uppercase converted field is equal to the non-converted field, the field must have been uppercase to begin with.
Mar 10 '10 #2
TheSmileyCoder
2,322 Expert Mod 2GB
Curious, did this work for you?
Apr 7 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: tanas | last post by:
Is there a way to convert lower case text to upper case text in PHP? Any help would be appreciated. Thanks
17
by: Janice | last post by:
char* line = "abcd"; How to convert the line to upper case and print? Any option for printf to do this? Thanx
2
by: Richard Keller | last post by:
How can I only allow user to enter upper case letters into a text box, and if he enters a lower case letter, change it to upper case. in vb6 I would use the keypress event and change the key to...
6
by: Aaron Smith | last post by:
Is there a way to put a limit on the text size of a datagrid column? Thanks, Aaron -- --- Aaron Smith Remove -1- to E-Mail me. Spam Sucks.
9
by: Tony | last post by:
Hello, In a textbox it is possible set charapters to upper with this property : CharacterCasing = Upper In a treeView not is possible... In Vb i set in a Event form KeyPress --> keyascii =...
6
by: MLH | last post by:
Using A97. Want to examine 17-char VIN entered by user. VIN codes are alphanumeric and do not contain Oh's to prevent the confusion that could result if zeros were misread as O's or o's. So, if...
10
by: evanburen | last post by:
I'm trying to text the text inside id="DirectorsCaption" within the hideDirectors() and showDirectors() functions but it's not working. I'm trying different variations using .innerHTML but with no...
1
by: Satya | last post by:
Hi, I am new to GDI+ in C# and so excuse me if this sounds silly. I need to draw text at different places on the form (mainly TopLeft, TopRight, BottomLeft and BottomRight). I can use either...
2
by: Kevin Blount | last post by:
I have reason to use a text field outside of a <formtag, but I'm having trouble checking the value of the form. The idea is to grab the field value and append it to a redirect. The problem is I...
2
by: slizorn | last post by:
hi guys, i need to make a tree traversal algorithm that would help me search the tree.. creating a method to search a tree to find the position of node and to return its pointer value basically i...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.