Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-18-2011, 07:50 AM   #1
duthiedon
Donner
 
Join Date: Dec 2007
Location: Ottawa, Canada
Posts: 60
Thanks: 17
Thanked 1 Time in 1 Post
duthiedon is on a distinguished road
MS Access 2007 and the Infamous Memo Field

Have a database that produces documents for public distribution, and the use of memo fields are extensively used. Most of the time we can get buy using the standard rich text that is provided with MS Access, but I'm trying to find a solution to include a table that is produced in MS Word and that we can copy and paste. Hopefully the solution will also fix where you may have a bulleted list (i.e. (a), (b), (c), (d)) and when you paste it into MS Access, it fails to recognize the original formatting and behaves oddly. Any suggestions?

duthiedon is offline   Reply With Quote
Old 10-18-2011, 08:13 PM   #2
Alansidman
AWF VIP
 
Alansidman's Avatar
 
Join Date: Jul 2008
Location: Lake County, IL
Posts: 1,493
Thanks: 40
Thanked 244 Times in 243 Posts
Alansidman will become famous soon enough
Send a message via Skype™ to Alansidman
Re: MS Access 2007 and the Infamous Memo Field

Where are you trying to do this? In a report? If that is the case, then this video may help.
http://www.datapigtechnologies.com/f...einreport.html
You can use this concept with a word document and insert it into a report and it should maintain formatting.

Alan
Alansidman is offline   Reply With Quote
Old 10-19-2011, 05:01 AM   #3
duthiedon
Donner
 
Join Date: Dec 2007
Location: Ottawa, Canada
Posts: 60
Thanks: 17
Thanked 1 Time in 1 Post
duthiedon is on a distinguished road
Re: MS Access 2007 and the Infamous Memo Field

Thanks, the user needs to be able to create/edit within a form, and the output is produced in a report. Any suggestions? I also don't want to loose the exsting content that is already stored.

duthiedon is offline   Reply With Quote
Old 10-19-2011, 07:00 AM   #4
Alansidman
AWF VIP
 
Alansidman's Avatar
 
Join Date: Jul 2008
Location: Lake County, IL
Posts: 1,493
Thanks: 40
Thanked 244 Times in 243 Posts
Alansidman will become famous soon enough
Send a message via Skype™ to Alansidman
Re: MS Access 2007 and the Infamous Memo Field

I am not getting what you are trying to accomplish. Perhaps you should upload your data base with some sample data and also using the sample data explain what you are looking for as expected results.
Alansidman is offline   Reply With Quote
Old 10-19-2011, 09:17 AM   #5
duthiedon
Donner
 
Join Date: Dec 2007
Location: Ottawa, Canada
Posts: 60
Thanks: 17
Thanked 1 Time in 1 Post
duthiedon is on a distinguished road
Re: MS Access 2007 and the Infamous Memo Field

I'm using a field type of "memo" with a rich text setting. I know there's limitations to the rich text implemented in MS Access. Users copy text from MS Word and want to retain the same format and layout. They would like to manipulate the text in MS Access as well.

In the attachment entitled "Desired Text Layout" is the word version and what I need to capture in the database for display on the form (and editing) and subsequently presented in reports.

If you do a simple copy and paste from word (particularly in example 1 where bullets are utilized), the format of the bullets are not retained, and not sure why. Obviously graphics and table formats are not supported by MS Access.

Is there any solutions? Any help would be greatly appreciated. I tried add-on this morning, but it doesn't satisfy the problem with tables and/or graphics.
Attached Images
File Type: jpg Desired Text Layout.jpg (57.4 KB, 251 views)
File Type: jpg Form Result.jpg (39.2 KB, 240 views)
duthiedon is offline   Reply With Quote
Old 10-19-2011, 10:19 AM   #6
Alansidman
AWF VIP
 
Alansidman's Avatar
 
Join Date: Jul 2008
Location: Lake County, IL
Posts: 1,493
Thanks: 40
Thanked 244 Times in 243 Posts
Alansidman will become famous soon enough
Send a message via Skype™ to Alansidman
Re: MS Access 2007 and the Infamous Memo Field

I tried to recreate your issue. I added a field to a table and then made my form a datasheet display. I set the properties in the table to Memo and set the text format as rich text. No other changes to the properties. I then took a Word file that had bullets and formatting in it. I cut and pasted the word file into the field in the form. As you can see, it pasted correctly.

I'm stumped at this point. Hopefully, someone else will have had this issue and knows how to resolve it.
Attached Images
File Type: png 2011-10-19_1324.png (46.5 KB, 281 views)
Alansidman is offline   Reply With Quote
The Following User Says Thank You to Alansidman For This Useful Post:
duthiedon (10-21-2011)
Old 10-21-2011, 05:27 AM   #7
duthiedon
Donner
 
Join Date: Dec 2007
Location: Ottawa, Canada
Posts: 60
Thanks: 17
Thanked 1 Time in 1 Post
duthiedon is on a distinguished road
Re: MS Access 2007 and the Infamous Memo Field

Thanks for your help. I'm pretty sure the problem is associated with the type of bullets we're using (i.e. (a), (b),...). I'm still looking for a solution, even a 3rd party solution that would work, but to no avail. Essentially I'm looking for an editor that behaves like MS Word.


duthiedon is offline   Reply With Quote
Reply

Tags
memo field , word 2007

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 Linked Oracle table, Memo Field issue nd_j Queries 1 09-26-2011 09:27 AM
Access 2007 ColumnHistory Memo Field to SQL Server 2008 Abdulkawi Forms 0 01-17-2011 02:31 PM
Amending memo field contents crashes 2007 Allan Forms 1 02-24-2010 09:43 PM
How can my memo/text box expand so i can read the whole thing? access 2007 yepwingtim Forms 5 03-26-2009 01:40 PM
Format selected text in RTF Memo field in MS Access 2007 ACF General 0 06-27-2007 11:47 PM




All times are GMT -8. The time now is 04:56 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World