Solved

Access 2003 All Capital Letters

Posted on 2007-12-06
5
6,416 Views
Last Modified: 2010-02-02
I have an Access 2003 database and I want all text to be entered to be in capital letters. I know I can put UCase in a query but is there some way that in the tables it just automatically goes to caps ?
0
Comment
Question by:Pdeters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 75
ID: 20421597
In the format property of the field put this character:

>


mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 20421602
Format Property - Text and Memo Data Types
See AlsoApplies ToExampleSpecificsYou 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.        **************THIS ONE ****
0
 
LVL 75
ID: 20421617
Note:  This will *display* as all UPPERCASE, not actually story the data that way.

IF ... on a form you wanted to actual *Convert* the text to upper case, then you could do this in a text box's AfterUpdate event:

Private Sub Text1_AfterUpdate()
    Me.Text1 = LCase(Me.Text)
End Sub

mx
0
 

Expert Comment

by:MeggittDASEA
ID: 20469189
Note, if you want to convert all text to upper case, you should use "UCase" and for lower case, you use "LCase".

Thus for Uppercase, for the text box AfterUpdate event, you put in the code builder.
Private Sub XXXXX_AfterUpdate()
    Me.XXXXX = UCase(Me.XXXXX)
End Sub
0
 
LVL 75
ID: 20469468
"but is there some way that in the tables it just automatically goes to caps"
Note ... keywords .. In The Tables :-)

mx
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question