Prefixing a note with user name / date & time

[mykal66]

Hi
I am a regular on the excel forum but this is my first delveinto access for many many yrs and stuck on one thing.
I downloaded a template issue tracker and managed to changeeverything I needed for my own use but I have a history section which saves anddate/ time stamps the comments but (and it’s annoying more than rendering thedatabase unusable) I cannot get rid of the word Version – see attachedscreenshot.
If it’s possible I’d rather have the comment prefixed withthe user name, date and time then the notes e.g. [Mfialko 07/03/2019 09:50:55]then the notes.
I assume it is something to do with this line but every timeI try to change it I end up with an error message

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

I have attached a screenshot of how the comments currentlysave

Than you

[OBP]

You do not actually say where this takes place.
Is it in the Control Surce of the History Field?
How does the user enter the "comment"?
How are you estbalishing the User?

[PhilS]

My advice would be to redesign this part of the application and use your own table for these comments containing user name, date of writing and the actual comment as separate columns. You can then format the history in any way you like.