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?
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