I need to convert upper to lower case.

[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

 

[Brendan Reynolds]

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

 

[Frank Martin]

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