Truncate a field

  • Thread starter Thread starter OEB
  • Start date Start date
O

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.
 
You should be able to use the Left() function like:
=Left([set as a memo], ...number of characters...)
 
Thanks! That works great.

Duane Hookom said:
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


OEB said:
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.
Click to expand...
Click to expand...
 
Back
Top