memo field is truncated to 255 characters

[sheniece via AccessMonster.com]

Helo all, I crated a word template with some custom doc properties. my form
has a memo field, my code converts the value to the memo field to a string
but when i assign the memo field to the doc property it gets truncated after
255 characters. any help would be appreciated. the following, is the partial
code:

Dim prps As Object
Dim strInterventionActivity As String

strInterventionActivity = Nz([Forms]![EditNote]![tbxInterventionActivity])

prps.Item("InterventionActivity").Value = strInterventionActivity

 

[sheniece via AccessMonster.com]

i forgot to mention when I

Debug.Print strInterventionActivity

the entire text is printed not just 255 characters.

Helo all, I crated a word template with some custom doc properties. my form
has a memo field, my code converts the value to the memo field to a string
but when i assign the memo field to the doc property it gets truncated after
255 characters. any help would be appreciated. the following, is the partial
code:

Dim prps As Object
Dim strInterventionActivity As String

strInterventionActivity = Nz([Forms]![EditNote]![tbxInterventionActivity])

prps.Item("InterventionActivity").Value = strInterventionActivity

 

[sheniece via AccessMonster.com]

it seems as though when i assign the string to the document property the
document property can only assign the first 255 characters of the string, is
there a workaround.


prps.Item("InterventionActivity").Value = strInterventionActivity

Helo all, I crated a word template with some custom doc properties. my form
has a memo field, my code converts the value to the memo field to a string
but when i assign the memo field to the doc property it gets truncated after
255 characters. any help would be appreciated. the following, is the partial
code:

Dim prps As Object
Dim strInterventionActivity As String

strInterventionActivity = Nz([Forms]![EditNote]![tbxInterventionActivity])

prps.Item("InterventionActivity").Value = strInterventionActivity

 

[Dirk Goldgar]

Helo all, I crated a word template with some custom doc properties. my
form
has a memo field, my code converts the value to the memo field to a
string
but when i assign the memo field to the doc property it gets truncated
after
255 characters. any help would be appreciated. the following, is the
partial
code:

Dim prps As Object
Dim strInterventionActivity As String

strInterventionActivity = Nz([Forms]![EditNote]![tbxInterventionActivity])

prps.Item("InterventionActivity").Value = strInterventionActivity

Is there any reason to believe that the document property is not itself
limited to 255 characters?

 

[sheniece via AccessMonster.com]

yes, the doc property is limited to 255 characters.

Helo all, I crated a word template with some custom doc properties. my
form

[quoted text clipped - 12 lines]

prps.Item("InterventionActivity").Value = strInterventionActivity

Is there any reason to believe that the document property is not itself
limited to 255 characters?