Trim

S

Sarah Ann

I want to display the first 500 characters of a memo field in a report. Does
anyone know what I would have to right in a Query or SQL to achieve this?
 
F

fredg

I want to display the first 500 characters of a memo field in a report. Does
anyone know what I would have to right in a Query or SQL to achieve this?
Click to expand...

Add an Unbound control to your report.
Set it's Control Source to:

=Left([FieldName],500)
 
Top