S
sg
I have set up a drop-down box in my form with about 7 choices on it.
However, some of the choices are too long to fit. So, I used the following
macro to fill in the drop-down:
Sub OnExitReinsured_Contracts()
Select Case ActiveDocument.FormFields("Reinsured_Contracts").Result
Case "Membership service agreements"
ActiveDocument.FormFields("Reinsured_Contracts").Result =
"Membership service agreements pursuant to which the Reinsured retains
financial responsibility for eligible health care services provided to"
Case "The indemnity policies"
ActiveDocument.FormFields("Reinsured_Contracts").Result = "The
indemnity policies written by the Reinsured to cover its"
I now have two problems:
1. When I choose the first option listed in the macro "Membership service
agreements" from the drop-down box, it fills in the entire text for me.
However, the text is running off the page and I can't get it to show up. If
I add a new line in the macro window, all the text on the new line turns red.
2. If I choose the 2nd option listed in the macro, nothing happens. The
text on the drop down is not replaced.
I think my problem is that I am trying to populate the same drop-down box
that I am choosing from, but I don't know what else to do.
I am fairly new at this and appreciate any help anyone can offer.
However, some of the choices are too long to fit. So, I used the following
macro to fill in the drop-down:
Sub OnExitReinsured_Contracts()
Select Case ActiveDocument.FormFields("Reinsured_Contracts").Result
Case "Membership service agreements"
ActiveDocument.FormFields("Reinsured_Contracts").Result =
"Membership service agreements pursuant to which the Reinsured retains
financial responsibility for eligible health care services provided to"
Case "The indemnity policies"
ActiveDocument.FormFields("Reinsured_Contracts").Result = "The
indemnity policies written by the Reinsured to cover its"
I now have two problems:
1. When I choose the first option listed in the macro "Membership service
agreements" from the drop-down box, it fills in the entire text for me.
However, the text is running off the page and I can't get it to show up. If
I add a new line in the macro window, all the text on the new line turns red.
2. If I choose the 2nd option listed in the macro, nothing happens. The
text on the drop down is not replaced.
I think my problem is that I am trying to populate the same drop-down box
that I am choosing from, but I don't know what else to do.
I am fairly new at this and appreciate any help anyone can offer.