Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Abay Abay is offline
external usenet poster
 
Posts: 8
Default Word 2003 / # in table cells

Hello ... the situation ... I export a file from Access 2003 to a "Rtf"
file for Word. This creates a table in Word with the exported fields. One
of the fields is a "Memo" field in access and shows all the data in Access.
However word fills the corresponding cell with the "#" character.

This does not happen to all rows in the table .. only some. I can go back
in to Access and copy and paste the correction information into the cell.

Any help with this would be most appreciated as I would really like to not
have to cut and paste.

Abay


  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2003 / # in table cells

What exactly are you exporting from Access? - a report? a query? ??

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Abay" wrote in message
...
Hello ... the situation ... I export a file from Access 2003 to a "Rtf"
file for Word. This creates a table in Word with the exported fields.
One of the fields is a "Memo" field in access and shows all the data in
Access. However word fills the corresponding cell with the "#" character.

This does not happen to all rows in the table .. only some. I can go back
in to Access and copy and paste the correction information into the cell.

Any help with this would be most appreciated as I would really like to not
have to cut and paste.

Abay



  #3   Report Post  
Posted to microsoft.public.word.tables
Abay Abay is offline
external usenet poster
 
Posts: 8
Default Word 2003 / # in table cells

I am exporting the results of a query, which includes the memo field ..

"Doug Robbins - Word MVP" wrote in message
...
What exactly are you exporting from Access? - a report? a query? ??

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Abay" wrote in message
...
Hello ... the situation ... I export a file from Access 2003 to a "Rtf"
file for Word. This creates a table in Word with the exported fields.
One of the fields is a "Memo" field in access and shows all the data in
Access. However word fills the corresponding cell with the "#" character.

This does not happen to all rows in the table .. only some. I can go
back in to Access and copy and paste the correction information into the
cell.

Any help with this would be most appreciated as I would really like to
not have to cut and paste.

Abay





  #4   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2003 / # in table cells

How is the export being performed?

If I open a query in Access that includes memo fields and then select
ToolsOffice LinksPublish IT with Microsoft Office Word, the document that
is created includes the text of the memo fields in the default normal font.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Doug Robbins - Word MVP" wrote in message
...
What exactly are you exporting from Access? - a report? a query? ??

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Abay" wrote in message
...
Hello ... the situation ... I export a file from Access 2003 to a "Rtf"
file for Word. This creates a table in Word with the exported fields.
One of the fields is a "Memo" field in access and shows all the data in
Access. However word fills the corresponding cell with the "#" character.

This does not happen to all rows in the table .. only some. I can go
back in to Access and copy and paste the correction information into the
cell.

Any help with this would be most appreciated as I would really like to
not have to cut and paste.

Abay





  #5   Report Post  
Posted to microsoft.public.word.tables
Abay Abay is offline
external usenet poster
 
Posts: 8
Default Word 2003 / # in table cells

Hello Doug,

Apologies for not getting back to you sooner .. have been away for a few
days ... I just tried the "publish it" approach, & it looks good. The
problem occurs on my office database, so will try it again tomorrow there &
hopefully it will work there too.

Many thanks for your help which is most appreciated.

Abay

"Doug Robbins - Word MVP" wrote in message
...
How is the export being performed?

If I open a query in Access that includes memo fields and then select
ToolsOffice LinksPublish IT with Microsoft Office Word, the document
that is created includes the text of the memo fields in the default normal
font.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Doug Robbins - Word MVP" wrote in message
...
What exactly are you exporting from Access? - a report? a query? ??

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Abay" wrote in message
...
Hello ... the situation ... I export a file from Access 2003 to a "Rtf"
file for Word. This creates a table in Word with the exported fields.
One of the fields is a "Memo" field in access and shows all the data in
Access. However word fills the corresponding cell with the "#"
character.

This does not happen to all rows in the table .. only some. I can go
back in to Access and copy and paste the correction information into the
cell.

Any help with this would be most appreciated as I would really like to
not have to cut and paste.

Abay







Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Multiplied Cells in Word 2003 Table Lenny Tables 4 February 26th 08 03:55 PM
Locking word 2003 table cells Paul L. Page Layout 1 May 21st 06 08:48 PM
Sorting table cells in word 2003 Doc colleena Microsoft Word Help 7 February 15th 06 12:57 AM
Sum Above table with merged cells in Word 2003 Lynn Taylor Microsoft Word Help 2 March 25th 05 02:37 PM
Text space in table cells in Word 2003 (using Windows XP) Jaykay Tables 1 December 2nd 04 11:16 AM


All times are GMT +1. The time now is 08:14 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"