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

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

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