Jim Dettman
jimdettman at earthlink.net
Mon Apr 28 09:21:47 CDT 2003
John, Two things that you may be thinking of: 1. Access internally uses the pipe symbol as a place holder for where data is to be inserted, but it does not do the actual insertion. This appears mostly in error messages in A2 when Access screws up and has not finished formatting the message, but displays it anyway. 2. Access also uses the pipe symbol within a string to force an EVAL(). i.e. "|rst![FieldName]|". That does force an actual substitution. Not sure if that really helps or not, but I'd be careful of using a pipe character with Access because of this. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Monday, April 28, 2003 9:28 AM To: AccessD Subject: [AccessD] Using the pipe character in strings Long ago (in a galaxy far far away) I remember looking at the open source libs from Microsoft. They used the pipe symbol | to insert information into a string. Does anyone know how they accomplished this feat? In short, I need to have a string of text with dates inserted in various places. "Blah blah blah Date blah blah Date" etc. Of course, being the "reusable code" kinda guy I am, I want to do it with a pair of tables with the main text going in the parent and the dates (or pointers to controls) going into the child. Pull out the parent text string, start replacing the | with child records (dates, or contents of controls on forms). Has anyone done this kind of thing? John W. Colby Colby Consulting www.ColbyConsulting.com ----------------------------------------------------- eMailBoss puts you in command of your email. Get your copy today at http://www.eMailBoss.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com