[AccessD] Using the pipe character in strings

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


More information about the AccessD mailing list