急，请教access问题

[shena]

请问如何通过vba去除某个字段中纪录所含有的回车？

谢谢

[富察咪咪]

试试查ASSIC

[test7979]

Replace(字段, vbCrLf, "")

[changechange]

dim conn as new adodb.connection
conn.open "连接字串你自己写"
'参考 http://access911.net/index.asp?board=4&mode=3&recordid=78FAB71E1BDC
conn.execute "update 表 set 字段=replace(字段,vbcrlf,'')"

[shena]

谢谢各位！