Related Topics

Upper & Lower Case

Upper & Lower Case in table
I would like to have a field in our table programmatically create the first letter of a word in a phrase as Upper Case (Capital) and the other part of each word in lower case as the user types the data

ie: Skiing Is Fun In Alberta

not: SKIING IS FUN IN ALBERTA or skiing is fun in alberta


Upper & Lower Case in table
I would like to have a field in our table programmatically create the first letter of a word as Upper Case and the balance of each word in lower case.

ie: Skiing Is Fun

not: SKIING IS FUN or skiing is fun


Changing the ase of data in afield
I've purchased & downloaded this Zip Code Database which has every Zip zcode in the U.S. which I use for different projects/reasons. The problem is, ALL of the data is upper case letters. I was wondering if in Access (or Excel) is there any way I could convert all of the letters (except the first letter) from upper case to lower case letters


Changing the ase of data in afield
I didn't quite know how to word my inquery. I've purchased & downloaded this Zip Code Database which has every Zip zcode in the U.S. which I use for different projects/reasons.

The problem is, ALL of the data is upper case letters. I was wondering if in Access (or Excel) is there any way I could convert of the letters (except the first letter) from upper case to lower case letters?


Upper and Lower case characters a challenge!
I'm not a programmer and have searched for so many hours trying to figure out if there's any way I can get MS Access queries to not see matches when alphanumeric character strings vary by only one uppercase character (or lowercase character).

I have 15 characters that generally the last 4 change, mostly the last 2, but are two separate records separated by one character, eg, XXXXXXXXXXXXXXB and XXXXXXXXXXXXXXXb. I'm trying to link over a million records with these type of id's and have permanent keyboard imprints on my forehead.

I couldn't possibly be the only one out here with this issue? Anyone encounter this and figure it out? I would really, really, realllllly, REALLLY appreciate the help.

Trying to find the light upper and lower case way,


Convert Text to Proper Case or Upper Case in Microsoft Access
When users are entering data into your Microsoft Access database, there may be times where you wish to view the information in the Microsoft Access forms, or store the information in your database tables, using a particular text case format. Microsoft Access contains functions that will convert input in to Proper Case, Upper Case and Lower Case, and the first two are discussed here.


Converting all text input to lower case
This seems incredibly simple, yet, I can't get it to work.

I'd like to have all user inputs into a form (or a table, for that matter) to be converted to lower case before saving.

In essence, all data must be converted to lower case and whatever data is displayed in the table is lowercase.

From the table, I've tried changing the format of the respective field to "<" but that doesn't seem to solve the problem. For some odd reason, the data still behaves as a string with uppercase characters (and this is displayed when the data is clicked. I can see the original string with the upper case characters) even though the string looks like the conversion had been made.

I also tried to modify the form directly, by using the OnChange event = =LCase([Process Path].[Text]), where Process Path is the name of the field in question.

However, this seems to do the same thing as setting the field format to "&gt


Changing the case of text
I would like to change the case of text in one column of a table or a report from caps and lower case to all upper case. I expected it to be a simple thing to do, but I haven't been able to formulate a question for the help function, or for the search funtion in this forum, that produces the answer. I'm working in Access 2000.


Tricky Recursive Function
hope everyone is well.

I need to create 20 separate strings of 12 numbers in the following format:

Lower boundary = 0, Upper boundary = 12

Each string needs to be unique, and I need to be able to parse any two numbers to the lower and upper boundaries. Have a couple of ideas but they're probably the long way round


input Validation
I have an unbound field that is used to enter for a new password.

On the event, before the input is encrypted and written into the table, I would like to check for the string to make sure it contains at least one upper case, one lower case and one number.


Count values outside of upper/lower limits
My query that contains the fields

Result
LowerLimit
UpperLimit

I need a way to calculate the total number of Result values that fall outside of the upper and lower limits. What would be the best way to do this?


Create a query to differentiate between upper and lower case
In Access 2003/XP/2000/97, I have a table with a field that either has a 'P' (uppercase) value or a 'p' (lowercase) value. I need to write a query that can recognize the case difference. How can I do this?


Is there a way to force a field do be upper case?
Is there a way to force a field do be upper case?
I want to change the user input to upper case.


A Naming Scheme for Database Tables and Fields
Database developers have historically used a somewhat cryptic system for naming database tables and fields. Originally a result of the limitations of database management systems (DBMS), these naming schemes - or the lack thereof - have become adopted by convention and tradition. However, as database applications become more complex, with more tables and larger teams of developers, and as developers come and go, it becomes much more important to implement a robust and disciplined naming scheme for database objects. A well-defined naming scheme becomes more important when you adopt object relational mapping (ORM) technologies or automatic code generation
This article presents one scheme that has worked for me for years in multiple successful commercial applications.
Perhaps the most common practice in database naming is to use all one case (upper or lower) with words separated by underscores, and heavily abbreviated. Fixed case names have become the standard because database systems are traditional case-insensitive in table and field names (or required fixed case). It is also a holdover from academia where use of a single case is common not just in database design, but in programming languages (for example, C language is traditionally taught in lower case and FORTRAN in upper case). Separating words with underscores is a natural result of fixed case names and also is commonplace in academia. The heavy use of abbreviations is a holdover from the days of dBase and other systems where there was a stringent limit on table and field name length. Many database designers schooled in the older systems still retain this use of abbreviated names in a severe case of the psychological principle of learned helplessness.


Forcing text to upper case
I am trying to use a form to populate a table and would like to know how I can make the text all upper case, no matter what was entered in the form?

I know this is probably very easy, but nothing I've tried has worked


make textbox lookup values case insensitive
I have a textbox in a form that has a lookup list. It is not limited to the list because it is there to state who purchased something, so it could be anyone, but there are several individuals and businesses that are constantly making the purchases. Not everyone who uses the form in the office consistently uses the same case when typing, which is fine, but the lookup only works when it is typed the same as the lookup, upper first then lower. I want to be able to run a query based off of certain purchasers, but the only way I can get other users to have it the same way is if it comes up when typed.

Can I make the lookup case insensitive?

I hope that ramble makes sense to people other than me, and


Calculating Values in a Query
I have 4 fields in a query, Drawing Dim., Tolerance, Upper Limit, and Lower Limit. I am trying to calculate the Upper and Lower Limit fields by taking the Drawing Dim. +/- the Tolerance (this works fine on my form for entering the data).

The problem is that the Tolerance is a combo box (dropdown), and the user chooses from values in the table. I am pretty sure this is why I am getting a Data Type Mismatch Error in my query, but I can't figure out how to get it to work.


Count uppercase letters
I have field in one form with number of letters in upper and lower case with spaces. I need to count number of upper case letters only and put the number in different field.

Me.Text47 = Len([Work Order])

"Work Order" - field with letters to be count
"Text47" - field, where result must put.

But this code counts letters with spaces.


Count uppercase letters
I have field in one form with number of letters in upper and lower case with spaces. I need to count number of upper case letters only and put the number in different field. I found following code:

Me.Text47 = Len([Work Order])

"Work Order" - field with letters to be count
"Text47" - field, where result must put.

But this code counts all letters with spaces. Can you please help to change this


is access case-sensitive?
I'm working on a web site using asp and ms access. if someone wants to login he/she enters a username and a password in flash textboxes, then I have an asp page that checks the username and the password. it worked fine until a user that had registered with an uppercase username wanted to login with a lower case (same) username but couldn't. how can I do the case insensitive check? many people have registered already, I don't want to change their usernames into lower case, I just don't want the check to care about it. is access case sensitive or not anyway?