[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