insert memo feild into a memo field truncates at 255 characters -

[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

 

[Ken Snell]

Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

 

[Billp]

arrrrrrrrrr - thoughts here.
Project_Notes is the Memo field.
After some pain I cut the memo field up into blocks of around 255 characters
and insert step by step.
Sorry for the delay in posting a response just returned to home base after
being at the branch where I asked the question.

Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

--

Ken Snell
http://www.accessmvp.com/KDSnell/

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

.

 

[Ken Snell]

I don't even see a Project_Notes field in the code that you posted. Makes it
difficult to try to debug with you without having information... but glad
you found a workaround. If you'd give us much more details about your code
and query, we may be able to help you get back to where you wanted to be,
without the workaround.
--

Ken Snell
http://www.accessmvp.com/KDSnell/

arrrrrrrrrr - thoughts here.
Project_Notes is the Memo field.
After some pain I cut the memo field up into blocks of around 255
characters
and insert step by step.
Sorry for the delay in posting a response just returned to home base
after
being at the branch where I asked the question.

Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

--

Ken Snell
http://www.accessmvp.com/KDSnell/

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

.

 

[Ken Snell]

Mmmm, ok I see where you have Project_Notes field name in your string
variable. I assume that tblProjectNotes_Input is a table, not a query?

See Allen Browne's website for detailed information about truncation of memo
fields:
http://allenbrowne.com/ser-63.html

This URL shows two posts from Jamie Collins where he tested 7 different
scenarios for possible memo trunction:
http://groups.google.com/group/micr...4e2d1b65a60e7/489970072eafe7a3?hl=en&lnk=st&q

--

Ken Snell
http://www.accessmvp.com/KDSnell/

I don't even see a Project_Notes field in the code that you posted. Makes
it difficult to try to debug with you without having information... but
glad you found a workaround. If you'd give us much more details about your
code and query, we may be able to help you get back to where you wanted to
be, without the workaround.
--

Ken Snell
http://www.accessmvp.com/KDSnell/

arrrrrrrrrr - thoughts here.
Project_Notes is the Memo field.
After some pain I cut the memo field up into blocks of around 255
characters
and insert step by step.
Sorry for the delay in posting a response just returned to home base
after
being at the branch where I asked the question.

Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

--

Ken Snell
http://www.accessmvp.com/KDSnell/



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


.