I need a way to make access force the first letters of each entry into a field as a cap and the rest as lowercase. I currently have many records all in caps and they need to be changed to just the first letter of each word being a capital. I have looked inside of access and tried a few different settings in a Text field and format setting but nothing so far has worked. What can I enter or do to correct this?
