blog comments powered by Disqus
To convert a database from mixed to upper or lower case, open Design View, select the field, right-click, then select Properties and the Format tab. Type a greater than symbol (>) in the Format field to convert the data in the field to uppercase. Use a less than symbol (<) to convert to lowercase. Remember this is a parameter for the data and the data itself will not be changed, just the way it is displayed.