[AccessD] Using the pipe character in strings

John,

The way I've seen it is in a form of concatenation which essentially
says, substitute the current value for the field name that I've inserted
in this string between pipes.  As I mentioned in another post, we ran
into problems with it after Access 97, so we stopped using it.

Charlotte Foust

-----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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com