B
Billp
Greetings I have a table that has a memo field to retain specific information
- text - which is the base of the combo box.
Via a combobox on a form this memo field is added to a forms field which is
also sized as a memo called "Project_Notes" - this part works.
At a certain time the user uploads this form and its feilds to a parent
table which also has a memo field to recieve the data from the other memo
field.
'we have created the new entry now we should update the notes
strOtherFields = ",Action_By,To_Do_date" _
& ",[Project_Notes],Status"
strsql = "INSERT INTO [tblsubProjectNotes] " _
& "(Works_Number" & strOtherFields & ") " _
& "SELECT '" & rst1!Works_Number & "' As
NewWorks_Number" _
& strOtherFields & " FROM tblProjectNotes_Input " _
& "WHERE Works_Number='" & rst1!Works_Number & "'" _
& "AND tblProjectNotes_Input!Sent_Input = False;"
the memo field is greater than 255 characters.
On INSERT the memo field is truncated to 255 characters.
Is there a way to get around this or resolve it ???????????
Thanx in advance.
Best Regards
- text - which is the base of the combo box.
Via a combobox on a form this memo field is added to a forms field which is
also sized as a memo called "Project_Notes" - this part works.
At a certain time the user uploads this form and its feilds to a parent
table which also has a memo field to recieve the data from the other memo
field.
'we have created the new entry now we should update the notes
strOtherFields = ",Action_By,To_Do_date" _
& ",[Project_Notes],Status"
strsql = "INSERT INTO [tblsubProjectNotes] " _
& "(Works_Number" & strOtherFields & ") " _
& "SELECT '" & rst1!Works_Number & "' As
NewWorks_Number" _
& strOtherFields & " FROM tblProjectNotes_Input " _
& "WHERE Works_Number='" & rst1!Works_Number & "'" _
& "AND tblProjectNotes_Input!Sent_Input = False;"
the memo field is greater than 255 characters.
On INSERT the memo field is truncated to 255 characters.
Is there a way to get around this or resolve it ???????????
Thanx in advance.
Best Regards