Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Sep 6 17:16:03 CDT 2004
Hi Robert: Something like: strSentence = ""This is a "Fine" Day we are having to day"" if left(strSentence,1) = chr(34) then strSentence = mid(2,strSentence) if right(strSentence,1) = chr(34) then strSentence = left(strSentence, len(strSentence)-1) ...and that should take care of whether there is a """ or not at the beginning or end as well. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Robert Gracie Sent: Monday, September 06, 2004 2:52 PM To: Access Developers discussion and problem solving Subject: [AccessD] Remove Beginning & Ending Quotes of a string Example "This is a "Fine" Day we are having to day" I need to remove only the first and last quotes. This is a "Fine" Day we are having to day Robert Gracie www.servicexp.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com