Access 2007 Memo Field append only?

[ARC]

This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot find
the append only option. Does anyone know how to use this feature?

------------------

"Memo fields are useful for storing large amounts of information. With
Office Access 2007, you can set the Append Only property to retain a history
of all changes to a Memo field. You can then view a history of those
changes. This feature also supports the tracking feature in Windows
SharePoint Services so that you can also use Access to view your SharePoint
list content history."

[Tony Toews [MVP]]

"ARC" <an**@andyc.comwrote:

>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot find
the append only option. Does anyone know how to use this feature?

I haven't used that feature myself but is the MDB file in A2007 format?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Peter Doering]

ARC wrote:

This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]

[ARC]

Yes it is in the 2007 format, in fact it is in the .accdb format.
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:en********************************@4ax.com...

"ARC" <an**@andyc.comwrote:

>>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

I haven't used that feature myself but is the MDB file in A2007 format?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[ARC]

I'm not seeing this option in the table design props. It is in accdb format.
It is a memo field, format is rich text.
"Peter Doering" <no****@doering.orgwrote in message
news:5h*************@mid.individual.net...

ARC wrote:

>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]

[ARC]

Ok, scratch that!

No wonder no-one ever finds this feature!! In table design on the field, the
very last property only is NOT visisible. You have to scroll down one line
to see it. Talk about well-hidden!

"Peter Doering" <no****@doering.orgwrote in message
news:5h*************@mid.individual.net...

ARC wrote:

>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]

[ARC]

Ok, I have it set now. However, when I go to the text box on the bound form,
I can't get it to function. If I type in new stuff, save, then right-click
and show column history, I get a message "Could not find field".
"ARC" <an**@andyc.comwrote in message
news:9f****************@nlpi070.nbdc.sbc.com...

Ok, scratch that!

No wonder no-one ever finds this feature!! In table design on the field,
the very last property only is NOT visisible. You have to scroll down one
line to see it. Talk about well-hidden!

"Peter Doering" <no****@doering.orgwrote in message
news:5h*************@mid.individual.net...

>ARC wrote:

>>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]

[Peter Doering]

ARC wrote:

Ok, I have it set now. However, when I go to the text box on the bound
form, I can't get it to function. If I type in new stuff, save, then
right-click and show column history, I get a message "Could not find
field".

I have not seen this message before. Make sure you are in form view (vs.
layout view), or try directly in the table. If that doesn't work either,
try again in a new DB.

--
Peter Doering [MVP Access]