Hey, Ok where to start, I'm usin 1

[SpankYou]

Hey,

Ok where to start, I'm using Microsoft Access to connect to Access Accounts Horizons. From this I have inserted some tables into Microsoft Access using ODBC. This is fairly irrelevant, but will help explain my problem. Basically the accounts package has an orders section with a description field, and each time a carriage return is entered into this field a square is placed in the description field within Microsoft Access. When I produce a report this square is still visible, and when convert to the word format it implements these carriage returns, and the report is all over the place.
Is there anyway of getting rid of the carriage returns before I send it to the report. I've tried to select this square (carriage return) and use the replace function, but the square cannot be selected through copy and paste.
Oh by the way no data can be edited from the Access Accounts Horizons from within Microsoft Access, so I'm not even sure if there is anything that can be done in access it may be a word issue.

Any ideas that may help would be great.

Thanks for any help

Sam

 

[xlbo]

You can do a find and replace in code
The "square" is almost certainly either char(10) or char(13)

you can use the ASC function (ie ASC(10) ) to reference this object and implement the find and replace in code

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[SpankYou]

Hey Geoff,

I tried the replace code n it didnt work (although it should have) but dont fear TonyJollans has sorted the problem out thread703-603843 for your help

Sam

 

[SpankYou]

Just checking through some old threads,

That should have said thanks for your help,

Anyway cheers

Sam

 

[xlbo]

No worries Sam - you been reading that thread in the "IT ethics" forum ;-)

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[SpankYou]

Your damn right I have, i thought I'd said more thank yous than I had, but I've just covered every thread I've missed, and now feel better for it.

Cheers

Sam