Lower case in memo field

  • Thread starter Thread starter Karen_H
  • Start date Start date
K

Karen_H

I want to convert ALL characters in a memo field to lower case in my report,
even though the form that feeds the report may have a mix of upper and lower
case data entry. When I put < in the format property for the field in the
report OR in the form, the field contents are getting truncated after 245
characters. Any suggestions?
 
In the Control Source of the text box put:

=LCase(YourMemoField)

Good luck.

Sco
 
I want to convert ALL characters in a memo field to lower case in my report,
even though the form that feeds the report may have a mix of upper and lower
case data entry. When I put < in the format property for the field in the
report OR in the form, the field contents are getting truncated after 245
characters. Any suggestions?
Click to expand...

Don't use any formatting in the memo field.
Instead add an UNBOUND control to the report.
Set it's Control source to:

=LCase([MemoField])

You'll get the full length of the field ... in lower case.
 
Back
Top