I have an Access 2000 DB and I need to reformat all the entries in a field to PROPER case (It's the name of the function) So it would look like: "Hello All." Even if you type "hello ALL" it will format it for me.

I'd like to set up so that new entries format it this way.....and a way to force all old fields to the new format.

It didn't say in the Help file how to do it.