How do you change the case in Microsoft Access?

Sar616 · #1 (**permalink**) 11-11-2007, 04:02 AM

i have rows and columns that have names typed in but not all of them are capitalized with the first letter. How do I capitalize the first letter without re typing it all. I have Access 2003
how do you do that?

Daniel G · #2 (**permalink**) 11-11-2007, 04:02 AM

Do an update query. Update field to UCase$([Field]).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode