ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:56PM] (1 Viewer)

[lateefx]

ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:56PM]

When you use the ColumnHistory method to auto-populate a field in a form - say for a history of comments or notes - is there a way to edit the text that is auto-entered before the actual comment or note?

Right now it appears like this for example:

[Version: 12/4/2009 5:20:56 PM ] New one again?

[Version: 12/4/2009 5:18:30 PM ] Yes new comment

[Version: 12/4/2009 5:17:49 PM ] Still worky

Ideally, I'd like a comment or note entry to read like this instead:
[12/4/2009] New one again?
[12/4/2009] Yes new comment
[12/4/2009] Still worky


not a very important note: I added custom VB code to reverse the result listings (from new to old..instead of old to new as is the default)

 

[boblarson]

Re: ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:5

I do not believe you can modify the text that is entered as that is part of the built-in functionality. If you want it without then you will have to create your own field or table to track history.

 

[lateefx]

Re: ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:5

Thanks Bob - I've already done so much customization to this database's forms - I think that default text will have to remain just a little longer. Especially, since I can't think of an easy way to track history in a separate table.

 

[BJJones13]

Re: ColumnHistory - Can you change the text displayed "i.e.[Version: 12/4/2009 5:20:5

I found a way to modify the output by using the Replace Function.

Sample code to take out the Version and replace it with just a bracket.
=Replace((ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))),"[Version: ","[",1,-1)

This:
[Version: 5/24/2011 1:34:23 PM ] Test History
[Version: 5/24/2011 1:40:10 PM ] Test it again
[Version: 5/24/2011 1:40:30 PM ] Test it a third time
[Version: 5/24/2011 1:53:19 PM ] Test 4

Becomes this:
[5/24/2011 1:34:23 PM ] Test History
[5/24/2011 1:40:10 PM ] Test it again
[5/24/2011 1:40:30 PM ] Test it a third time
[5/24/2011 1:53:19 PM ] Test 4

I hope this might help someone out there.