[AccessD] Remove mulipule vbCrlf From the end of a string?

On 31 Jul 2006 at 7:24, Max Home wrote:

>  
> str = Left(str, (InStr(str, vbCrLf) - 1))
> 

The sample has multiple vbCrLfs embedded.
This would truncate it at 
"Service Order # 67468 On a True 3 Door Prep Table M # TSSU-72-18"



> Regards
> Max
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
> Sent: Sunday, July 30, 2006 11:37 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Remove mulipule vbCrlf From the end of a string?
> 
>   
>  Does anyone have a procedure handy to Remove multiple vbCrlf From the end
> of a string?
> 
> String Example:
> 
> Service Order # 67468 On a True 3 Door Prep Table M # TSSU-72-18
> Invoice Date: 4/27/2006
> Invoice Total: 105.79
> Customers Complaint: Replace condensate pan
> 
> Services/Notes Performed: Install Drain Pan & 3 Clips Tested Ok JB
> 
> Remove vbCrlf here
> Remove vbCrlf here
> Remove vbCrlf here 
> Remove vbCrlf here 
> 
> Thanks 
> Robert
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart McLachlan