Pasting text into access from word

  • Thread starter Thread starter Steve Bu
  • Start date Start date
S

Steve Bu

Hi I am experiencing the following problem when copying and pasting text
into an access form from word.

Any tab(s) in the original word document appear in the pasted text in access
as a character similar to a bold I.

Is there any way of preventing this?

I would appreciate any assistance.

Thanks

Steve B
 
Hi Steve,

Unfortunately this is normal behaviour: the Access textbox doesn't know
about tabs. There's no simple alternative either: possibiities include
using a rich text control instead of the textbox, and setting
appropriate tab widths in the control; or using a fixed-width font in
the textbox and writing code to replace each tab character with the
necessary number of spaces.
 
Hi John,

Thanks for taking the time to respond,

I did feel I was in trouble, I will have a look at the options you mentioned
however the code solution is out for now as I have no experience.

Once again

Thanks

Steve Bu
 
Hi Steve,

For rich text controls: there are several around, but not all work
satisfactorily on Access forms. Two that are designed to do so are the
free one at www.lebans.com and the full-featured Total Access Memo at
www.fmsinc.com .

Hi John,

Thanks for taking the time to respond,

I did feel I was in trouble, I will have a look at the options you mentioned
however the code solution is out for now as I have no experience.

Once again

Thanks

Steve Bu
 
Thanks John,

As it happens, I have just come across the FMS site and looking at their
offerings now.

Thanks

Steve Bu
John Nurick said:
Hi Steve,

For rich text controls: there are several around, but not all work
satisfactorily on Access forms. Two that are designed to do so are the
free one at www.lebans.com and the full-featured Total Access Memo at
www.fmsinc.com .
 
Back
Top