Lower case in memo field

[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?

 

[M.L. Sco Scofield]

In the Control Source of the text box put:

=LCase(YourMemoField)

Good luck.

Sco

 

[fredg]

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?

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.