Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access 2007
Resolved · Medium Priority · Version 2007
Reply Tue 24 Jun 2008, 16:13Delegate Emma said...
Emma has attended:
Access Intermediate course
Access Advanced course
Access 2007
How can I change a colum which has been typed in capitals to lower case?
For upcoming training course dates see: Pricing & availability
RE: Access 2007
Hi Emma
Thank you for your question.
You can force any entry into lowercase by using an input mask of the form <###########. This will only work for new data
If you want to change existing data into lowercase then you wil need to build a query and create a calculated field.
Using the expression builder, click on the functions folder and select 2built in functions", select text function and double click on Lcase. You must then apply this function to the field in question.
Hope this is useful. Let me know if you need further clarification
Regards
Stephen
|