Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-18-2014, 01:53 PM
macropod's Avatar
macropod macropod is offline Age calculation with date and DOB fields Windows 7 32bit Age calculation with date and DOB fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

Xaand,

There are some fundamental problems with your attached document:
1. The field code you are using is NOT the same as the textual representation of it that appear in the document and that you have posted online. A glaring difference is that you've changed some of the switches in the field code to something quite incompatible with the calculations;
2. You have inserted the formfields inside content controls!!! Formfields and content controls are not meant to be used in the same document, let alone one inside the other.
Fix those issues and the calculation field will work correctly.

As for "it might have something to do with updating fields", the formfield 'calculate on exit property takes care of that. If you use content controls, though, a different approach would be required (e.g. a macro or Ctrl-A, F9).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Age calculation with date and DOB fields Rules based due date calculation dlowrey Excel Programming 3 05-12-2013 08:30 PM
Age calculation with date and DOB fields calculation if either of two fields is entered BritBiker2 Excel 5 01-29-2013 09:12 AM
Age calculation with date and DOB fields Date Calculation Lights Excel 5 04-18-2012 04:31 AM
calculation of start date ketanco Project 1 02-29-2012 07:01 AM
how to make fields calculation variable according to the filter i use duraid Project 0 09-09-2010 01:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 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