Find/Replace code - line wrap problem

[David R]

Hi Dave
I know about Chr(13) & Chr(10) and about vbcrlf. The problem is not about how I can include 'new lines' in a Find and in a Replace - not about how I can create new lines in a MsgBox, or in an Append, or in an .Update !!
I'm sorry that I hadn't made this clear
Les

I am completely confused then. In the time it has taken to run this thread for the last couple of days you could have manually done Find&Paste on several thousand lines of code...

I think Rookie is correct and that F&R will not do what you want.

 

[Les Isaacs]

Hi Dave
You are absolutely right: the problem was that you were making suggestions that I needed to reply to. Each time I believed that I could get my point across, and that you - or someone - might come up with a solution! In retrospect, as you say, perhaps I should have simply done the job manually - but where's the learning in that
Thanks for all your help
Les

 

[David R]

Sorry we wasted each other's time, then.

 

[WayneRyan]

Les,

I think this is achievable.

This link seems to show the tools available, even though its for Excel VBA:

http://www.cpearson.com/excel/vbe.aspx

This part might pertain to you "Adding A Procedure To A Module".

hth,
Wayne

 

[Les Isaacs]

Hi Wayne
Thanks for coming in on this: and from my very quick look at the link you gave I'm confident that this is the solution to the problem
I won't be able to implement this until later this week, but will post back to confirm that all is well (or that I'm struggling )
Thanks again
Les

 

[spikepl]

Plan B would be to dump relevant database objects into text files http://www.access-programmers.co.uk/forums/showthread.php?t=99179 change them there using, say, Word macros, and read them back in.