type mismatch error?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angyl - 02 Nov 2006 17:24 GMT

I'm moving data inputted into a userForm to Form Fields in a word document
and I need to multiply some of the data by 12 (because I'm going from monthly
to yearly amounts). This code:

.FormFields("txtAnnualGross1").Result = WCInfo.txtMonthlyGross1

Does the job just fine of getting the base, (entered as monthly gross) into
the form field, but when I try:

.FormFields("txtAnnualGross1").Result = WCInfo.txtMonthlyGross1 * 12

I get a type mismatch error. How do I get this thing to let me multiply the
result by 12 before putting it in the form?

Reply to this Message

Jonathan West - 02 Nov 2006 18:27 GMT

> I'm moving data inputted into a userForm to Form Fields in a word document
> and I need to multiply some of the data by 12 (because I'm going from
[quoted text clipped - 12 lines]
> the
> result by 12 before putting it in the form?

Do your type conversions explicitly, like this

.FormFields("txtAnnualGross1").Result = CStr(Val(WCInfo.txtMonthlyGross1) *
12)

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

Angyl - 02 Nov 2006 19:27 GMT

You rule...

> > I'm moving data inputted into a userForm to Form Fields in a word document
> > and I need to multiply some of the data by 12 (because I'm going from
[quoted text clipped - 17 lines]
> .FormFields("txtAnnualGross1").Result = CStr(Val(WCInfo.txtMonthlyGross1) *
> 12)

Reply to this Message