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

Fred Hooper fahooper at trapo.com
Mon Jul 31 17:00:40 CDT 2006


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





More information about the AccessD mailing list