The Proper Case Address Function in Access
Convert your address fields into proper case with Microsoft Access functions. Instead of manually changing each record to create a consistent format with your address fields, employ functions to automate the work process. Create a query based on the address field table. Then, create a calculated field to use the proper case function on your addresses.
Other People Are Reading
-
Functions
-
Access provides functions to perform a variety of tasks. Functions can calculate values, locate records and format text. You can add a function to a control from the Expression Builder window. You can build an expression from scratch or from a menu. The way you create an expression depends on the object you are using, whether it's a table, query, form or report. Open your object in "Design View" and open the Property Sheet to access the expression tools.
String Conversion Function
-
You can turn your address fields into proper case without manually changing the values. Use the String Conversion function to automatically update your address records into proper case format. Type the String Conversion function in the following format without the quotation marks: "StrConv([Address],3)" The "StrConv" is the function, the [Address] is the field, and the "3" is the setting that turns your address field into proper case. Functions are very specific, so be careful with your syntax.
-
Query Design
-
Use queries to change the case of your address field in your Access database. If your address data is already stored in a table, create a query that is based on that table data. If you already have a query based on the table, right-click its name in the Navigation Pane and select "Design." Slide the horizontal scroll bar to a new column and type the String Conversion function into the field row.
Error Message
-
Functions rely on perfect syntax because a computer can only analyze data if it matches certain parameters. If you receive an error message after typing your function, return to the query design. Check that the field is encased with brackets and that a comma separates the field and the number 3. Check the function spelling and make sure your parentheses surround the criteria. Return to datasheet view from the Home tab of the Ribbon to view your changes.
-
References
- Photo Credit Jupiterimages/Photos.com/Getty Images
