Ok so I kind of found an answer to my problem... The Access field is a Rich Text Format. If I disable RTF then vbCr/vbLf/vbCrLf worked flawlessly. ^_^

The negative is I can no longer save text as italics, bold, or etc...

OMG! I got it lol!

2 Minutes later...

Ok so I had additional code I forgot was running. The code retrieved the info from the access database and removed all html tags. All I had to do was add back the html tags and access interprets them as line breaks: <br></br> or <p></p>

Apologize for forgetting about the RemoveTags function. It was buried within ten thousand of lines of code.

Thanks so much for all your help!