Help Removing Word Tab Symbol Please

[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

 

[Douglas J. Steele]

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

 

[Helen Wheels]

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

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

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

 

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

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

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

 

[Helen Wheels]

Douglas

Thank you - it works like a charm!

I really appreciate your kind help and your shared expertise.

Helen