470,614 Members | 1,569 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

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."
Aug 4 '07 #1
7 8680
"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/
Aug 4 '07 #2
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]
Aug 4 '07 #3
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/

Aug 5 '07 #4
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]

Aug 5 '07 #5
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]

Aug 5 '07 #6
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]


Aug 5 '07 #7
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]
Aug 5 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

49 posts views Thread by Allen Browne | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.