Leading whitespace in data being stripped out

[Kevin Bilbee]

We just upgraded from Office 2000 to 2007 and our merge data that started
with a tab character now seems to be ignoring\striping the leading tab
character. This character is used for formatting.

How do I get office 2007 to not ignore\strip leading whitespace characters?


Kevin Bilbee

 

[Doug Robbins - Word MVP]

I would suggest that you put the tab in the appropriate place in the mail
merge main document.

--
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

 

[Kevin Bilbee]

OK my bad. Sometimes ther is data infront of the tab. So placing the tab in
the document will not work.


The places this happens we are prefomatting multi-line data so it will wrap
properly on the page.

Any other suggestions?



Kevin Bilbee

 

[Peter Jamieson]

To be honest, I can't remember which types of data source used to preserve
white space at the beginning of fields, but what type of file is your data
source?

Peter Jamieson

 

[Kevin Bilbee]

MS Access database file.



Kevin Bilbee

To be honest, I can't remember which types of data source used to preserve
white space at the beginning of fields, but what type of file is your data
source?

Peter Jamieson

 

[Peter Jamieson]

Check Word Tools|Options|General|"confirm conversions at open", go through
the process of connecting to your database again, and select the DDE option
when offered.

Peter Jamieson