Truncate a field

[OEB]

I have a report based on a query and only want to show the first 550
characters in the field (set as a memo in the table) because the report is
getting very long showing all the historical statuses. How do I do that?
Thanks.

 

[Duane Hookom]

You should be able to use the Left() function like:
=Left([set as a memo], ...number of characters...)

 

[OEB]

Thanks! That works great.

You should be able to use the Left() function like:
=Left([set as a memo], ...number of characters...)

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

I have a report based on a query and only want to show the first 550
characters in the field (set as a memo in the table) because the report is
getting very long showing all the historical statuses. How do I do that?
Thanks.