Re: converting all letters in field to small letters?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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.
"Mani" <Mani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:615DABEA-B9FF-4A5A-9EC5-651B03F92B9A@xxxxxxxxxxxxxxxx
> converting all letters in field to small letters?
>
> How is it done?
.
Relevant Pages
- Re: Clipping words short in cells
... various volumes and whatnot for each shot. ... The letters I'm bringing in from ... report to report can vary so I need to write the program such that it will ... use a query and add that as a new field. ... (microsoft.public.access.modulesdaovba) - Re: Sorting alphanumeric values
... you need to create a query that has the appropriate ORDER BY ... For a report, you must use the Sorting and Grouping dialog to set the order, ... letters for example 21BC123, so I left it as a text field because I didn't ... The part numbers sort ... (microsoft.public.access.gettingstarted) - Re: Need help with printing from Access!
... print out end of year donation letters. ... However when I try to print out the actual letters ... It would seem that there is an error in the report, ... It should be a query (again, I can't see it so I don't know what ... (microsoft.public.access.gettingstarted) - Re: Sorting alphanumeric values
... but I did use a query to make the report. ... sort properly either. ... letters for example 21BC123, so I left it as a text field because I didn't ... (microsoft.public.access.gettingstarted) |
|