Access VBA remove CR & LF only from the beginning of a text string by searching for them

Posted by uZI on Stack Overflow See other posts from Stack Overflow or by uZI
Published on 2010-03-28T15:16:00Z Indexed on 2010/03/28 15:23 UTC
Read the original article Hit count: 269

Hi there

I need to remove line breaks from the beginning of a memo type records. I dont want to use the replace function as it would remove all line breaks from the record which is not desired. Its only the line breaks at the beginning of the field that I am interested in removing.

Furthermore, the my records do not always begin with a line break so I cant really use text positioning, the solution would be to look for line break at the beginning instead of always expecting it at the beginning.

click here for a sample of what my data looks like

any help will be greatly appreciated

© Stack Overflow or respective owner

Related posts about access-vba

Related posts about search-and-replace