changing case

M

mikeL

this is a repost. sorry for the duplication, but realized
late this might be a better place for the question:

How do I change the capitolized names in a table to all
small case in the results of a query.

this is in Access02

thanks,
mike
 
D

Duane Hookom

Use LCase() to display a values as all lower-case.
lAddress: LCase([Address])
 
G

Greg Kraushaar

You can use LCase([FieldName])
or you can simply specify "<" in the format property of the fileds you
want to change
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word doc keeps changing to ALL CAPS 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Getting Radio Buttons to work, that are inserted via AutoText 0
VBA word change keys 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Make one final list from four sources 1
Case Sensitive Query 7

Top