Ray - According to MS Office support:
Text fields in desktop databases (.accdb)
Long Text In .accdb files, the Long Text field works the same as the Memo field of old. That is, it can store up to about a gigabyte of text, even though controls on forms and reports can only display the first 64,000 characters. You can set Long Text fields to display Rich Text, which includes formatting like bold and underline.
But that doesn't say anything about what you can see by viewing the field directly in the linked table. Have you tried opening the table and looking at the data?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <rayfrew@gmail.com> wrote :
Hi everyone
I'm trying to link my database to Outlook so that as emails arrive I can use them in Access. I followed the wizard (External Data / More / Outlook folder) and chose the option to "Link" and create a linked table. That worked fine. However, I noticed that the contents of the email is truncated. When I looked at the linked table created the data type is "Long Text" - is that significant?
If I had chosen the first option from the wizard which "Imports the source data" I get all of the email.
It seems as though I can have (1) linked tables showing up to date "partial" emails or (2) all of the email, just not up to date (I would have to refresh the table on a regular basis). Is there a way I can have all of the email and a true, up to date link to my Outlook system? I'm using Outlook 2013 and Access 2013.
Any ideas / pointers much appreciated.
Many thanks
Ray
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar