My application sends "Route For Review" emails using the SendObject command in a macro. The macro works just fine, and the SendObject works as expected, except... for the text plugged into the body of the email, which is fed from an UNBOUND field in the database:
Message: ="Rationale: "& forms!formname!fieldname
This approach does indeed plug in the text found in this field, but only the first "x" characters. Is there a 256 char limit on this argument in SendObject? If so, can you suggest a workaround to get the full text of the field?
Just guessing, I also tried creating a table behind the form that collects the rationale text, declaring that field a memo field, and then pitching THAT to the SendObject call, but that didn't work either. Sheesh!
Thanks in advance! -Scott/Chicago, IL USA
Message: ="Rationale: "& forms!formname!fieldname
This approach does indeed plug in the text found in this field, but only the first "x" characters. Is there a 256 char limit on this argument in SendObject? If so, can you suggest a workaround to get the full text of the field?
Just guessing, I also tried creating a table behind the form that collects the rationale text, declaring that field a memo field, and then pitching THAT to the SendObject call, but that didn't work either. Sheesh!
Thanks in advance! -Scott/Chicago, IL USA
