View Single Post
  #1  
Old June 26th, 2008, 05:56 AM posted to microsoft.public.access.queries
Joseph Walkenhorst
external usenet poster
 
Posts: 1
Default DAO parameter length

When I run the code below an error is thrown at line 4 when the string
sc.notes is greater than 255 characters.
Is there any way to allow parameters to contain more than 255 characters?

1 Public Function saveSCToDB(sc As Scorecard, query_Name As String) As Boolean
2 Dim qdf1 As DAO.QueryDef
3 Set qdf1 = EMAT_DB.QueryDefs(query_Name)
4 qdf1.Parameters("[@Notes]") = sc.Notes
....