Aside from the truncation issue, perhaps the Replace () function to get rid of carriage returns and line feeds will be helpful. Chr(10) Chr(13) if memory serves me.
Queries Field Join of URL not working
Sometimes Helpful
Windows 7 64bit 
Access 2010 32bit
Aside from the truncation issue, perhaps the Replace () function to get rid of carriage returns and line feeds will be helpful. Chr(10) Chr(13) if memory serves me.
Advanced Beginner
Windows 8 Access 2013
Thanks
I will review tomorrow morning.
I really appreciate your help.
Advanced Beginner
Windows 8 Access 2013
Worked!
Thanks this saved my project.
VIP
Windows 7 64bit Access 2010 32bit
Actually, it's Chr(13) & Chr(10) - concatenated in that order and assumes both characters are present. I did test an UPDATE with Replace() and it worked. However, not sure either was the character in this issue. Didn't need to know.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Can't figure out the best way to join queries
Left join not working like usual
Posting Permissions
Reply With Quote