Display Only Uppercase

[jamesfranklin]

Hi,

Display only uppercase and Lowercase String in Column.

Ex:

Department
DEPARTMENT


department



Display

DEPARTMENT
department

Thank you for ur valuable time in this post....

[alansidman]

If you are setting the property in a table, then look at this:

Format Property - Text and Memo Data Types

You can use special symbols in the setting for the Format property to create custom formats for Text and Memo fields.
Setting

You can create custom text and memo formats by using the following symbols.

Symbol	Description
@	Text character (either a character or a space) is required.
&	Text character is not required.
<	Force all characters to lowercase.
>	Force all characters to uppercase.

Custom formats for Text and Memo fields can have up to two sections. Each section contains the format specification for different data in a field.

[jamesfranklin]

Hi,
Thank u alansidman for ur reply

Could u please explain Briefly. I'm not clear with this.

Thank u for spend time in this post.

[alansidman]

When you set up your tables, there is a property section at the bottom for each field. Look to setting the Mask using the above criteria in the property section.

[jamesfranklin]

Hi,
Thank u alansidman for ur reply

K fine. But i need to display after entered into the column.

Display Uppercase alone and lowercase alone in different query.

Thank for ur valuable time spend in this post

[alansidman]

K fine. But i need to display after entered into the column.

Display Uppercase alone and lowercase alone in different query.

I don't understand what you are asking. Please clarify with a fuller explanation and examples.

Edit: Reread the original thread. I think this is what you need to do.

http://support.microsoft.com/kb/304258

This allows you to filter on the case of the records in your field.

[jamesfranklin]

Hi alansidman,

Thank u for ur reply. Ya Exactly what i needed. But its not worling.

I am using access 07.

Thank U

[orange]

Show us a sample of what is not working

try
MyTextField = UCase(MyTextField)

[jamesfranklin]

Hi,

Thank U for ur reply. I attached my file here. I don't know whether i'm using the query correct r not. please check it and give me the result.

1) Display only full String uppercase
2) Display only full String Lowercase


Thank u..

[orange]

No it isn't correct. But you must have known that when you ran your query.
The Upper/lower case is NOT a criteria. It is a display format.

Select UCase(yourFieldHere) from YourTableNameHere;

UCase for upper
LCase for lower

[jamesfranklin]

Hi orange,

Did u see my attachment file. Please Check it and give me some solution.

Thank u

[alansidman]

because Access treats upper case and lower case as the same, there is no function for this. However, here is a partial solution.

http://www.utteraccess.com/forum/Fil...-t1583790.html

This works to identify the last letter in a string as upper case and returns the records showing that. In your case you have some middle initials that throw a wrinkle in this solution. Suggest you play around with Right and Left and see if you can make it work for your case.

What you are asking for does not seem 100% feasible in Access.

[jamesfranklin]

Hi,

Thank u for ur reply.....

[jamesfranklin]

Hi,

Yet not over. please give me some solution. Thank u

[recyan]

If you are comfortable with VBA, you should be able to develop a function using ASC() and MID() (assuming, I have understood your requirement correctly :-)).Thanks