Trim

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a printed Access report can I Trim characters? 1
Truncated memo field display 3
corrupted memo field in multi-table query 6
Memo Field in Table Truncated in query results and in report 1
Query in vb.net not returning all characters in access memo field 1
Strange Asian looking characters in output 3
Memo type field size 7
Memo Field cut off in query 4

Top