[AccessD] Using the pipe character in strings

John W. Colby jcolby at ColbyConsulting.com
Mon Apr 28 12:08:43 CDT 2003


Yep.  But I am trying to make it table driven.  Which means the
"Forms!myForm!MyControlDate.Value" has to be interpreted first, i.e. that
exact string will be saved in a table and be pulled out of the table,
interpreted to a date (or other value) and dropped into the string.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Monday, April 28, 2003 11:10 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Using the pipe character in strings


Hi John

I wonder how you have spent the weekend ... ??

> Actually that is exactly what I am looking for.  I want to place the
> form!myForm!MyControl into the string and have it interpreted.

> .. In short, I need to have a string of text with dates inserted in
> various places.  "Blah blah blah Date blah blah Date" etc. ..

So:

strColby = "Blah blah blah " & Forms!myForm!MyControlDate.Value &
           " blah blah " & Forms!myForm!MyControlDate.Value & "" etc.

You may need to wrap the values in Format().

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-----------------------------------------------------
eMailBoss puts you in command of your email.
Get your copy today at http://www.eMailBoss.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2272 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030428/64c0496b/attachment-0001.bin>


More information about the AccessD mailing list