VBA string value Truncates and reads (???.????ú ? ???????.?.?y????ú ???? )

[sri123]

Here is the Scenario:
I have table with Column Name "Notes", one of these Notes record has below value
qqwerrrrrrqreqwerewrqewreqwrewrewioruioqweuroiuweo ruoweiquriuqweoruoweiuriouqweoriqwerrrrrrqreqwerew rqewreqwrewrewioruioqweuroiuweoruoweiquriuqweoruow eiuriouqweoriqwerrrrrrqreqwerewrqewreqwrewrewiorui oqweuroiuweoruoweiquriuqweoruoweiuriouqweoriwerrrr rrqreqwerewrqewreqwrewrewioruioqweuroiuweoruoweiqu riuqweoruoweiuriouqweori

I am trying to pull this value from table and trying to append for all records.

Set db = CurrentDb()

Set rs = db.OpenRecordset("qrySummaryNotes")
rs.Filter = "[tabName] = 'General'"
Set rsNew = rs.OpenRecordset
'dbNotes = rs.Fields("totalNotes")
If rsNew.RecordCount > 0 Then

If Not (rsNew.EOF And rsNew.BOF) Then

rsNew.MoveFirst

Do Until rsNew.EOF = True

dbNotes = rsNew.Fields("totalNotes")
strNotes = strNotes & vbCrLf & vbCrLf & dbNotes

rsNew.MoveNext

Loop
End If



Now the strNotes is reading half value correct: Please see below, why am I seeing these strange ?????

qqwerrrrrrqreqwerewrqewreqwrewrewioruioqweuroiuweo ruoweiquriuqweoruoweiuriouqweoriqwerrrrrrqreqwerew rqewreqwrewrewioruioqweuroiuweoruoweiquriuqweoruow eiuriouqweoriqwerrrrrrqreqwerewrqewreqwrewrewiorui oqweuroiuweo
???.????ú ? ???????.?.?y????ú ????
?? ?.???.?Ñ? 

? ???????.???y????????
?y?.????????????? ???

[June7]

You really have gobbledygook in field or you just intended that to represent data?

You want the same value copied to all records?

I don't understand the looping structure. What string are you trying to build? Maybe show sample records and desired result.

[sri123]

Well the data I have shown you was a sample one, am trying to store the history of Notes, at times the user may enter a long string..

Below is the sample data..

DateAdded	Notes	TabName
12/1/2014 0:00	fdsfdsfdsfsdfdasf	General
12/9/2014 0:00	dfasdfasdfdasfasd	General
12/23/2014 0:00	adfaefsdfds	General
11/26/2014 0:00	dfdsfasdf	General
10/29/2014 0:00	dsfasdfdasf	General
12/25/2014 0:00	dsfasdfasdfasdf	General
12/1/2014 14:31	This is to test General tab Control Comments section for Martech 100..	General
12/1/2014 14:46	This is to test the Mat Tech Id 10 in General tab	General

[June7]

That is the raw data? Dpesn't show me the result you want.

Are you trying to save a string that concatenates the date and note of all related records into table? Why would you even want to do that?