converting all letters in field to small letters?

J

John Spencer

Use either the StrConvert function or the LCase function.

Since you didn't say where - on a form, on a report, in a query - or when
that is about all anyone can tell you.
 
P

PC Datasheet

Me!NameOfMyField = LCase(Me!NameOfMyField)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
M

Mani

yah go away pcdatabase, i dont need YOUR help. You greedy idiot, this forum
is to help people not to make money.
 
M

Mani

i want to do it in a query.
So the underlying data in the field is changed to lowercase
 
D

Douglas J. Steele

If you're running the query from inside of Access, you can use the LCase
function in the query.
 

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

Help With Typing Russian Letters On Microsoft Word Mac 0
Keep First Letters, with exceptions 0
Mail Merge Directory Conditional Page Break 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Delete all data after a symbol in a field 0
VBA - exporting serial letters to single documents 0
Improving Macro That Keeps First Letter 0
Merging from an Excel file with graphics 1

Top