memo field is truncated to 255 characters

  • Thread starter sheniece via AccessMonster.com
  • Start date

S

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
 
Ad

Advertisements

S

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
 
S

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
 
D

Dirk Goldgar

sheniece via AccessMonster.com said:
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?
 
Ad

Advertisements

S

sheniece via AccessMonster.com

yes, the doc property is limited to 255 characters.

Dirk said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top