Forum Moderators: open

Message Too Old, No Replies

Newbie Access question

         

AsleepATheWheel

10:49 am on Oct 20, 2003 (gmt 0)

10+ Year Member



Hi, I have a little experience in programming, but very little with Access. My problem is that I want to Find and Replace all of the Carriage Returns in a table column, is there an easy way to do this? Word has this functionality built into it's Find and Replace, but Access doesn't seem to have.

Thanks for any help,

Paul

mattglet

12:16 pm on Oct 20, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



not totally sure if there is a way to do it directly in Access, but whenever i do it, i use the replace function in VBScript:

replace(mystring,chr(13),"<br>")

-Matt

AsleepATheWheel

12:34 pm on Oct 20, 2003 (gmt 0)

10+ Year Member



Ok, cheers for that, I'll give it a go.

Paul