daninthemix
Registered User.
- Local time
- Today, 03:23
- Joined
- Nov 25, 2005
- Messages
- 41
I have listboxes sourced from a table with string entries that are 255 chars long, and I've found that if the entry contains a carriage return then it can't open the form with the listbox.
Standard stuff, but it can't handle carriage returns. How do I change this?
Code:
stLinkCriteria = "[Note]=" & "'" & Me![lstNotes] & "'"
DoCmd.Close
DoCmd.OpenForm "Notes", , , stLinkCriteria
Standard stuff, but it can't handle carriage returns. How do I change this?