Printable View
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. :(
If this is a form for entry of data, set up an input mask (you should be able to do this using the wizard)
If it's a data table entry do the same on the underlying table proerties - set up the input mask there
If you want to reformat a subset of data ( a query or report) use the format command on the text box that displays the data - I'm pretty sure > will force all data to upper case, that is, enter > in the format property to convert hELLO to HELLO
Good luck