command "subtitute " in Access : How to insert "new paragraph&quo

[Fanny]

I need to import a Word database into Access. But I cannot succed in doing it : in each square and between each line in a square, is used the command "enter" (i.e.new paragraphe).
So I needed to "subsitute" this command (with a simple symbol)in all my file. (I finally could found how to do it: new paragraph is : ^p) And then I could export it in Access.

The problem I have now is that I would like to do the contrary in Access. But the Function "substitute" in Acces does not give me the opportunity to change a symbol into the "new paragraph " command : How could I enter "control+enter" (which is the command of new paragraph in Access) in "substitute with" ?

If somebody knows how to do with visual basic, please help me, I beleive that is the only solution I could find

 

[scking]

vbCrLf will give a new line and vbCrLf & vbCrLf will insert a space for a line. Before they had this intrinsic constant it was necessary to insert Chr(10) & Chr(13) for each carriage return line feed.

 

[Fanny]

Thanks a lot, but I am very new in Access and I don't know how to use the visual basic, can you help?
Thank you very much.
Fanny