Help Removing Word Tab Symbol Please

H

Helen Wheels

Hi

I'd be really grateful for any help on this.

I'm copying and pasting from Word into an Access table as I have data,
with bullet points, in a table in Word.

The problem I have is that Access is changing the tab space after
bullet points to a small box.

Is there a quick and simple way to change this? I've tried search and
replace by that doesn't work.

Many thanks for any help with this.

Helen
 
H

Helen Wheels

The Tab symbol is Chr(9), so try using Replace([MyText], Chr(9), " ")
Click to expand...


Hi Douglas

Thank you for your reply, but I've got no idea where I would even
begin with that!

I've got my table in Access - what would I need to do then?

Many thanks

Helen
 
I

i_takeuti

Helen Wheels said:
Hi

I'd be really grateful for any help on this.

I'm copying and pasting from Word into an Access table as I have data,
with bullet points, in a table in Word.

The problem I have is that Access is changing the tab space after
bullet points to a small box.

Is there a quick and simple way to change this? I've tried search and
replace by that doesn't work.

Many thanks for any help with this.

Helen
Click to expand...
 
D

Douglas J. Steele

Create a query based on that table. Add all of the fields to the query. For
the field that contains the tabs, use that Replace statement, rather than
simply the name of the field.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Helen Wheels said:
The Tab symbol is Chr(9), so try using Replace([MyText], Chr(9), " ")
Click to expand...


Hi Douglas

Thank you for your reply, but I've got no idea where I would even
begin with that!

I've got my table in Access - what would I need to do then?

Many thanks

Helen
Click to expand...
 
H

Helen Wheels

Douglas

Thank you - it works like a charm!

I really appreciate your kind help and your shared expertise.

Helen
 
Top