I have been modifying the Access 2007 downloadable “incident database” for use as a logging tool. Within this, each incident has a “Comment” field, which is a Memo box set to “Append After”, and the details form then uses the ColumnHistory() function to show the history of the comments added. This works just fine.
Now, I have had feedback from users. They want a space between each piece of history, to make it more readable, and they would like to see the most recent history item first. In the context in which they are using it, this makes more sense. However, I have satisfied myself that neither of these are possible with the ColumnHistory() function.
The better way to do this is to therefore to create a table with comments and to write a query to return all of the comments related to a particular issue, sorted with the most recent first. This is quite straightforward.
What doesn’t appear to be straightforward, though, is displaying this in the form. I would rather put the data into a text box than into a datasheet, simply because the comments will be of variable width and it will be more readable that way. But I cannot see how to get multiple records to concatenate into a single text box. How should I do this?
Thanks.
Stuart
