append to front when using ColumnHistory method

[Guest]

I am using a field as in the "Issues" template in Access 2007 that displays
the history of the field "Comments". The general function of recording and
displaying all the old comments is working fine. The only thing I'd like to
change is to either append each new comment to the front of the
"ColumnHistory" instead of the end, OR figure a way to at least display it
newest to oldest instead of the oldest on top/first.

It seems the default is to append data only to the end/bottom. The problem
with that is that the first comment in the list is the oldest comment and
when the list is larger than the display box then the user must always scroll
down to see the newest past comments.

any ideas?

 

[Guest]

Just reverse the concatenate statement.

If you do not understand then post the SQL/code statement so it can be
edited for you..

 

[Guest]

I'm, not sure how to get to the SQL code since this is being run through an
expression in the control source that calls the ColumnHistory method in
Access 2007.
here is my expression though.

=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

"Comments" is a text field. My table is "Ideas" which will also work in
place of [RecordSource].

I don't mind leaving the whole columnhistory thing behind if there is a
programming way too.

 

[Robert English]

Having used the Issues database within a larger database, I now find that, while I want to keep using the history section within the Issues part, I would like to delet the passed content from the history section. So far I can't find a way to do this and maintain data rcords for the rest.

I'd be grateful for any suggestions.

RE

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com