Carriage Return Issue - Importing Word Form Field to Access Text Box

[DubaiDave]

I am importing a form field from Word which looks like this:

1/ Houses
2/ Trees
3/ Peanuts

Once in the textbox it looks like this:

1/Houses(Little Square)2/ Trees(Little Square)3/ Peanuts.

I have tried replacing the CR charactesr as follows:

Haystack = ActiveDocument.FormFields("BackgroundInfo").Result
Needle = Chr$(10)
NewNeedle = Chr(13) + Chr(10)
Me.txtBox = SF_replaceAllOnce(Haystack, Needle, NewNeedle)

But no luck.

Can amyone tel me what characters I should be replacing and waht with?

Dubai Dave

 

[RuralGuy]

See if you can determine the little box character with this code:
MsgBox Asc(Mid([YourControl], 10, 1))
...changing the 10 to match your little box.

 

[DubaiDave]

Thanks RuralGuy,

It was ascii 13. Working now!

DubaiDave

 

[RuralGuy]

Glad I could help.