Form to Comment

[timely2]

I am trying to get information filled in a form to go both to a database and to one comment for cell for a related day. I already have it going to the database. Not sure how to get several entries into one comment.

I am using it for a role of all present at a meeting on a report.

Thanks
Tim

 

[rubbernilly]

Look at concatenation.

dim String1 as string, String2 as string
Dim String3 as String, Dim MyString as string

MyString = string1 & string2 & string3
debug.print mystring
[green]or with each entry on a new line...[/green]

MyString = string1 & vbcrlf & string2 & vbcrlf & _
           string3 & vbcrlf
debug.print mystring

That also works with concatenating the text in a textbox on a form before it goes to the report, and it can work in a query, too.

HTH

 

[timely2]

Thanks, I should be able to put that with other stuff that I found on comments.