Drew Wutka
DWUTKA at marlow.com
Mon Apr 28 18:59:00 CDT 2003
Someone already replied to this I am sure....but don't you just want the Replace function (which of course isn't in Access 97 or earlier......) Drew -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Monday, April 28, 2003 8: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