comment history in Access2007

[Sylvie]

Hello Group
I have a question about Comment history in Access2007. Does anyone know how
to display the comment history starting by the last text written first;
currently comment history keeps record from first entered to last entered. Is
there a way to see it the opposite? sometimes you just want to see what was
done last first?
Hope that makes sense.
Thanks for any help.

 

[Maurice]

Depending on the source of the object you can use a query to be the source
and set the query to be sorted by date descending that will put the oldest
comment first.

 

[Allen Browne]

Presumably we are talking about a Memo field in Access 2007, where the
Append Only property is set to Yes, so you use the ColumnHistory() function
to return a full history of each time the field was changed.

I don't think Access provides a way to see the values other than as a string
returned by ColumnHistory().

It would be possible to write some code to parse the string based on
locating vbCrLf & "[Version: ", and write it to a temporary table with the
date/time separated from the text, so you could sort/filter as desired.

 

[Sylvie]

thank you Both for your answers. Thanks Allen to clarify the problem. That's
exactly what it is. Your solution seems to be the only way. I have not tested
it yet but will try and see what happens. Thx again.

Presumably we are talking about a Memo field in Access 2007, where the
Append Only property is set to Yes, so you use the ColumnHistory() function
to return a full history of each time the field was changed.

I don't think Access provides a way to see the values other than as a string
returned by ColumnHistory().

It would be possible to write some code to parse the string based on
locating vbCrLf & "[Version: ", and write it to a temporary table with the
date/time separated from the text, so you could sort/filter as desired.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hello Group
I have a question about Comment history in Access2007. Does anyone know
how
to display the comment history starting by the last text written first;
currently comment history keeps record from first entered to last entered.
Is
there a way to see it the opposite? sometimes you just want to see what
was
done last first?
Hope that makes sense.
Thanks for any help.