Access VBA remove CR & LF only from the beginning of a text string by searching for them
- by uZI
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