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)