Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Trimming" end of a function 1

Status
Not open for further replies.

mbcmike

Programmer
Sep 9, 2005
34
US
I have a particular function that when shown in IE, takes up alot more space in the explorer then when I see it in the Crystal Report preview. So basically I want to limit this to a certain amount of characters. For example, functionX will only show the 1st 20 characters...even if it is 25 caracters long.
 
Its actually just a report field....sorry, don't know why I said function.
 
Try Left({your.field}, 20). There are also Mid and Right functions, if you need other sorts of trimming. Also Truncate, if you want 1.99 to show as 1.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top