Access 97 has many codes you can enter into Table Design view that allow advanced formatting and layout of data already entered. This is how to convert the format of your data to all capitals:

1. Select the table in the database task list, and click the Design button to the right of the list of tables. The skeleton design for the table with the field names and the properties of the fields will appear.

2. Click inside the First Name field to activate it.

3. Click inside the Input Mask field situated towards the bottom of the screen on the General tab of the field formatting area.

4. To convert all first names to capitalised first names, you need to type in the code >L<??????????
   

5. The > in the code tells Access 97 to make the first letter capitalised. The L tells Access 97 that a letter is required in the field, and the < tells Access 97 to reduce all following letters to lower case. The actual number of question marks you type in tells Access the maximum number of letters that can be entered, so it is suggested you type a reasonably large number here.
   
6. Click the Close button to exit the design screen and click Yes to save the design changes.

The same procedure can be repeated to convert the Last Name to capitalised names as well. When you enter data into an input mask formatted field, you’ll notice underscores, which is the default character, representing the number of ?s entered into the design view of the table:

• Home Based Business Opportunity Ideas In an attempt to balance career and home life, many people in this day and age are seeking a home...
• GOGO™ 3-Star 40mm Table Tennis Balls (144-pack), Ping Pong Balls - Orange User Reviews Send this to a friend GOGO™ 3-Star 40mm Table Tennis Balls (144-pack), Ping Pong Balls - Orange Manufacturer:...
• Restore Wordpress Database How to Restore your Wordpress Database The easy and secure way, using phpMyAdmin. A good backup copy of your database...
• Butterfly Carlos Chiu Table Tennis Racket User Reviews Send this to a friend Butterfly Carlos Chiu Table Tennis Racket Manufacturer: Butterfly Customer Rating: List Price: $69.99...
• How to catch hackers on your wireless network [/caption] Wireless networks are a wonderful invention. They give us the ability to easily deploy a complex network of computers...