Textbox Problem

  • Thread starter Thread starter Taffy-Taff
  • Start date Start date
T

Taffy-Taff

Guys -
I have a textbox that I will store information from a variable. Th
textbox will store a form of report based on some calculated figure.
want the following items to be displayed:

CONTACT MADE ON JUNE 10 : 15
CONTACT MADE ON JUNE 11 : 1
CONTACT MADE ON JUNE 12 : 2

The problem is that I cannot get each item to start in a new line.
use chr(10) between them but it does not work. I have no idea how man
lines of items will be displayed, as this information is stored in
loop. I keep getting this result:


CONTACT MADE ON JUNE 10 : 15 CONTACT MADE ON JUNE 11 : 1CONTACT MADE O
JUNE 12 : 2


How can I get each item to start in a new line in the textbox?
this is a sample of the code that I use:

STRCNT = \"CONTACTS MADE ON \" + STR(DTEE) + \" : \" + STR(DTEE_AMT)
STRREP = STRREP + CHR(10) + STRCN

and I am using MS Access.

Thanks

Taff
 
Taffy,

STRCNT = "CONTACTS MADE ON " & DTEE & " : " & DTEE_AMT
STRREP = STRREP & Chr(13) & Chr(10) & STRCNT
 
Back
Top