I need to convert upper to lower case.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have designed a report to print out bank
statements downloaded from the bank.

All works well, but the bank's long
transaction narratives are in upper case
which consume a lot of report space.

How can I convert the relevant report text
fields so that all text defaults to lower
case.

Please help, Frank
 
Thanks, this worked well. I used the
builder.
Regards,Frank


"Brendan Reynolds"
message
In the ControlSource property of a textbox
...

=LCase([FieldName])

Where 'FieldName' is the name of the field
you want converted to lowercase.

Here's a link to the on-line help topic for
the LCase function ...

http://office.microsoft.com/search/redir.aspx?AssetID=XT011352301033

--
Brendan Reynolds
Access MVP


message
I have designed a report to print out bank
statements downloaded from the bank.

All works well, but the bank's long
transaction narratives are in upper case
which consume a lot of report space.

How can I convert the relevant report text
fields so that all text defaults to lower
case.

Please help, Frank
Click to expand...
Click to expand...
 
Back
Top