Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 05-16-2012, 07:05 PM
macropod's Avatar
macropod macropod is offline Display result in textbox based on the input of another textbox Windows 7 64bit Display result in textbox based on the input of another textbox Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To see how, click Developer > Restrict Editing > Stop Protection.

Then click on the formfield and click Developer > Properties. You'll see that the fomrfield has a bookmark name and an option 'calculate on exit' that is checked.

Then press Alt-F9 to expose the field code for the forumula field.

That's all there is to it.

Do note that, with such a document, you can only enter data in the formfields. If you want to be able to enter data elsewhere, you need to use Section breaks to differentiate the Sections that will/will not have the formfield protection. See attached.

For an idea of what can be achieved with formula field coding, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...l=1#post320143
or
http://www.gmayor.com/downloads.htm#Third_party
Attached Files
File Type: doc FormDemo.doc (34.0 KB, 19 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to insert a hyperlink in activex textbox Joe Patrick Word VBA 1 10-03-2011 06:03 AM
textbox color issue Dave Duncan Word 0 08-07-2011 10:38 AM
Motion paths and shrinking textbox Brin PowerPoint 0 01-12-2011 10:04 AM
Textbox Template t0m46 Word 0 09-07-2010 03:38 AM
Creating Chart using VB textbox value shyler82 Word VBA 0 03-12-2010 06:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft