By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Access 2007 Memo Field append only?

P: n/a
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
Share this Question
Share on Google+
7 Replies


P: n/a
"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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.