Listboxes with carriage return entries

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.

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?
 

Users who are viewing this thread

Back
Top Bottom