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

Stuart,
 Works perfectly when used in a module, but when I create a function and use
it in a query, the results are all messed up, almost like the data gets
corrupted, all sort of weird characters.  I have confirmed the data is not
corrupt..

Any ideas?

Thank You Very Much!!
Robert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Sunday, July 30, 2006 6:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Remove mulipule vbCrlf From the end of a string?

On 30 Jul 2006 at 18:37, Robert wrote:

>   
>  Does anyone have a procedure handy to Remove multiple vbCrlf From the 
> end of a string?
> 

How about something like:

While Right$(strInput, 2) = vbCrLf
    strInput = Left$(strInput, Len(strInput) - 2) Wend
--
Stuart McLachlan


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com