[AccessD] Using the pipe character in strings

Use Eval()

If tSysfile!Formloc is a text field which contains 
"Forms!frmMain.txtDate" 
and
tSysFile contains a single record
and
frmMain.txtDate contains "1/1/2003" then

Eval(Dlookup("FormLoc","Sysfile") returns "1/1/2003"


On 28 Apr 2003 at 13:08, John W. Colby wrote:

> 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
> 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.