I have an Access 2003 mdb. On one of the forms there is a text box. Address text from the internet is copied into the clipboard . VBA code in the form then copies it into the form's textbox.
I have a routine that deletes any blank lines. The routine works just fine in
Access 2003, but I've copied the mdb to another computer with Access 2007 and,
for some reason it doesn't do the job. The program continues on ok, but doesn't
get rid of the blank lines.
This is the routine. I added the MsgBoxes to help me debug what is going on.
With the info below I get 1 of msg #1 and 1 of msg #3 :
Public Function NoBlankLines()
Const CRLFCRLF = vbCrLf & vbCrLf
Do While InStr([ipAddrInfo].Text, CRLFCRLF)
[ipAddrInfo] = Replace([ipAddrInfo], vbLf & vbCr, "")
Copied Info (7 lines):
801 W. SR 123, Suite 9999
Soda Springs, FL 33333