Results 1 to 2 of 2
2004-07-19, 09:48 #1
- Join Date
- Jul 2004
- Hertfordshire, England
- Thanked 0 Times in 0 Posts
How to format calculation form fields (Word 2002 on XP)
Hi, all. I'm new to the lounge and have been trying to come up with a solution to my problem for going on a week. Hoping y'all will be able to help...
I have a Word form template for creating a commercial invoice. A drop-down field (bookmark name is CurCurrency) allows the user to select the currency: CAN$, US$,
2004-07-19, 10:17 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: How to format calculation form fields (Word 2002 on XP)
Welcome to Woody's Lounge.
The format of a form field is read-only in Visual Basic. So instead of trying to modify the format, I would insert a cross-reference to the CurCurrency dropdown before each form field that represents a currency amount, whether entered manually or calculated. You do this as follows:
- Position the insertion point to the left of a form field that contains a currency amount.
- Select Insert | Reference | Cross-reference...
- Select 'Bookmark' as 'Reference type'.
- Select 'Bookmark text' as 'Insert reference to' (this is the default).
- Select 'CurCurrency' as 'For which bookmark'.
- Click 'Insert'.
- Repeat for other form fields.
Make sure that 'Calculate on exit' has been ticked for the CurCurrency dropdown.