Solved Column in Text Box (3 Viewers)

[JoséBob]

Hello,
Before I dive into finding the solution, I'd like to know whether it's possible to create columns in a text box?
The idea is to show the history of changes of a text box (Rich Text formatted) with the old value on the left and the new value on the right. Something like:
Changes on 01/01/1900 by User1:
Old value | New Value and blablabla
Changes on 02/01/1900 by User2:
New Value and blablabla | Other value

The history will be shown on an other form opened with an extra button "history".
Maybe using one field is not a good idea and I should try something better like two fields but I am not sure how to link-scroll two fields.

Thanks in advance for your support.

 

[bob fitz]

Might be better to use a subform or a listbox.

 

[CJ_London]

Only way would be to use spaces and carriage returns

Better to use a subform with two controls side by side

 

[MajP]

May be interested in columnhistory if Long text

Using ColumnHistory Expression in an Form

Hello Again all, I am attempting to use the below expression in my access field: =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) This was an example taken from a microsoft Template, "Customer Service" however I am attempting to get this to work in DB and it wont. I attach a...

www.access-programmers.co.uk

 

[arnelgp]

maybe what you need is an Audit Trail of all changes for your field.
If your column is a Long Text, you cannot have "changes" on that column because
to be able to access the ColumnHistory, the column must be Append Only.

 

[JoséBob]

Only way would be to use spaces and carriage returns

Better to use a subform with two controls side by side

Can the two controls be synchronized while scrolling?
To be sure I understand: two controls means two fields? e.g. one with the old values and one with the new values?

 

[JoséBob]

maybe what you need is an Audit Trail of all changes for your field.
If your column is a Long Text, you cannot have "changes" on that column because
to be able to access the ColumnHistory, the column must be Append Only.

The field parameter is "long text" and formatting is Rich text (with <div> as line break). Would it work?

 

[CJ_London]

Yes - you’ll need 3 controls, maybe more- one for the header, one each for old and new values plus perhaps more for bla bla

Put them all in the detail section of a continuous form

 

[arnelgp]

Would it work?

it will but without any clue Who made the changes.
Audit trail will show you who did any changes, but
that is entirely up to you.

Example of Audit trail:

https://blueclawdb.com/access-database/tutorials/audit-trail/

 

[JoséBob]

Yes - you’ll need 3 controls, maybe more- one for the header, one each for old and new values plus perhaps more for bla bla

Put them all in the detail section of a continuous form

I'll try that. I'll let you know. Thanks

 

[JoséBob]

And I keep The Audit trail in mind too. Thanks @arnelgp

​