Coulmns/Table Disappearing

[NealB]

Hello All,
I'm new to the forum. Hope you can help me. I created a new Access table, with cells defined as MEMO. I am copying small reports that contain columns, money totals, into the cells. I copy the data from WORD. When I run a report, the data is no longer in columns. It just strings across. Any idea how I can keep it in columns? Also, how do I remove the HARD RETURN characters from the report (the small squares)? Many thanks ! Neal

 

[suepowell]

Hi

I don't think you can include word formatting in a memo field, but I could be wrong.

Is the word data in a table, and are you copying and pasting or setting up some sort of import.

I think the best way to preserve the columns would be to have an access table with a field for each column, then you would have complete control over the layout of your report.

Is this feasible in your case?

If the data is a one off import, this might not be too bad, but if you need to do it reqularly, then you need to come up with a way of getting the data in without too much manual intervention.

Let me know a few more details and I will try to help

Sue

 

[NealB]

Thank you Sue.

I have attached a mini database as an example. Please look at the report I created. I copied the two paragraphs from a Word Perfect report into each "Guarantees" cell. Just below "The following table..." paragraph is where 3 columns of data should appear.

As you can see, special characters also appear that were not in the original text.

 

[NealB]

...The attached file did not work. May I PM the file to your Email ?

Neal

 

[suepowell]

Neal,
yes you can send a PM to my e-mail, but did you know that you have to zip the database to post it, you can't post a database in mdb format.

Sue

 

[NealB]

Zipped File attached. Hope it works!

 

[suepowell]

Hi Neal

Yes the zipped file worked fine.

This is a difficult one.

I think that you will need to set up some sort of input routine to read the word paragraph character by character, recognise the formatting characters, and replace them with ones that access can recognise.

I.m afraid this is not something I have much experience with, so I can't help anymore, over to someone else out there.

Sorry.

Sue

 

[Pat Hartman]

1. Relational database tables don't have cells. They have columns (or fields if you like). Spreadsheets have cells and cells work very differently from columns.

2. There are ActiveX products on the market that can be added to an Access db to support .rtf formatting. Your only other option is OLE fields that store actual documents and actually open Word.