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

You would need to replace two vbcrlfs with one.  That would keep
replacing until you had no double carriage returns. 


Charlotte

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Fred Hooper
Sent: Monday, July 31, 2006 3:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Remove mulipule vbCrlf From the end of a string?

How about string = replace(string, vbCrLf & vbCrLf, "")? This would
leave one at the end of the line. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Sunday, July 30, 2006 6: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