Normal Topic Problem with Xlookup in a Costum Box ˆJ (Read 688 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Problem with Xlookup in a Costum Box ˆJ
Feb 13th, 2007 at 9:18pm
Print Post Print Post  
Hello!

I use  a  Xlookup to get  data from a Single Line Text field to a Costum Box in my main Form.
the xlookup works fine but with ˆJ   (?)

Thank you for your Help

Dr. Belhareth
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Problem with Xlookup in a Costum Box ˆJ
Reply #1 - Feb 13th, 2007 at 9:22pm
Print Post Print Post  
^J is how a carriage return/line feed appears in a single line text box. This indicates a new line and single line boxes don't wrap, so it shows as ^J. The value you are returning with XLookup must have a newline in it.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Problem with Xlookup in a Costum Box ˆJ
Reply #2 - Feb 15th, 2007 at 7:53pm
Print Post Print Post  
..thank you very much Erika!
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged