a "simple" question about text box

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

Contact made on June 10 : 15
Contact made on June 11 : 1
Contact made on June 12 : 23

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


Contact made on June 10 : 15 Contact made on June 11 : 1Contact made on June 12 : 23


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) + strCnt

and I am using MS Access.

Thanks

Taffy

taffy, I have not used these before, but I have two suggestions that would be VERY easy to try out. First, I have usually seen these in this format Chr$(10) and Chr$(13) **note the $ after Chr**,and second to try is to replace the linefeed character with the carraige return character Chr$(13). Hope one of these helps. I would have tried them out before suggesting them, but I do not have access to a db just now.

best of luck.

mike

Hi Taffy,

I'm not very sure this can be achieved or not in the text box but alternatively u can use text area which can display the newlines and will allow scrolling

Hi!

You need to do two things to achive this:

1. Set the multiline property to true.
2. Use VBCrLF instead of CHR(10).

Cheers,