Send Object Message Text Help

  • Thread starter Thread starter Shawn
  • Start date Start date
S

Shawn

Hi,

I have an e-mail button on a data entry form. The Send
object reads in the description =[Forms]![Name of Form]!
[description] into the message. But, it cuts off the
description. It won't put the entire description into the
message. How can I fix this problem? Is there a limit to
the amount of characters that can carry over to the
message?

Thanks,
Shawn
..
 
Shawn said:
Hi,

I have an e-mail button on a data entry form. The Send
object reads in the description =[Forms]![Name of Form]!
[description] into the message. But, it cuts off the
description. It won't put the entire description into the
message. How can I fix this problem? Is there a limit to
the amount of characters that can carry over to the
message?

Thanks,
Shawn
Click to expand...

There may be a limit, but it's not very small -- I can get over 500
characters in with no problem. How big is the [description] field
you're trying to put in the message? Please post the code you're using;
maybe there's something there that is truncating the field contents.
 
Dirk,
This is the code(below) that I have in the message text
box of the Macro. Issue Description is setup as a "memo"
max of 65,000 characters (or something like that), but
when I carry it over to the e-mail, it appears that its
putting it over to text, 255 characters. That is my
guess. I'm certainly not getting 500 like you are.

="You have been assigned the following item from the ANO-1
SG/RVCH Action Tracking Database: " & [Forms]!
[Contingency Issues]![Issue Description]

Thanks,
Shawn
-----Original Message-----
Shawn said:
Hi,

I have an e-mail button on a data entry form. The Send
object reads in the description =[Forms]![Name of Form]!
[description] into the message. But, it cuts off the
description. It won't put the entire description into the
message. How can I fix this problem? Is there a limit to
the amount of characters that can carry over to the
message?

Thanks,
Shawn
Click to expand...

There may be a limit, but it's not very small -- I can get over 500
characters in with no problem. How big is the [description] field
you're trying to put in the message? Please post the code you're using;
maybe there's something there that is truncating the field contents.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
Click to expand...
 
Shawn said:
Dirk,
This is the code(below) that I have in the message text
box of the Macro. Issue Description is setup as a "memo"
max of 65,000 characters (or something like that), but
when I carry it over to the e-mail, it appears that its
putting it over to text, 255 characters. That is my
guess. I'm certainly not getting 500 like you are.

="You have been assigned the following item from the ANO-1
SG/RVCH Action Tracking Database: " & [Forms]!
[Contingency Issues]![Issue Description]
Click to expand...

I'll bet this is a limitation imposed by the way Access handles macros:
a lot of arguments, I've noticed, are limited to 255 characters, where
in the VBA equivalent they are not. I suggest you use VBA code instead
of a macro to perform this function. The equivalent to the macro
SendObject action is the VBA method DoCmd.SendObject, which has a
similar set of arguments. If you're not familiar with VBA coding and
don't feel up to transforming your macro into VBA on your own, post back
with a complete description of the macro, its actions and arguments, and
I'll help you with the transformation.
 
Back
Top