Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-25-2022, 09:21 PM
kcaron kcaron is offline How to tell if a legacy control changed Windows 10 How to tell if a legacy control changed Office 2021
Novice
How to tell if a legacy control changed
 
Join Date: Oct 2022
Posts: 3
kcaron is on a distinguished road
Default Clarification

I'm a bit confused between field codes {F9, a-F9, & c-F9} and field controls.

I've tried field code several times and rarely get them to work. I tried to calculate the end of the loan term by using the VBA function DateAdd("M", StartDate, nper), where StartDate and nper are numeric Text Form Fields. Can field codes reference these? I tried something like:
{ =DATAADD("m", {REF StartDate }, {REF nper} ) \@ "MM/dd/yyyy" }

But get
!Syntax Error, (

Sooo, instead I did everthing with Legacy Text Form Fields and the Exit field.
What I was initially asking, is there a way in the exit sub to tell if the formfield was actually changed?

My hack was to create Static variables then compare that static var value to the formfield value:
ActiveDocument.FormFields("StartDate").Result
if different, I update other FormFields, then before leaving, copy the current formfield value into the static variable.

This is mostly working but somewhere the static vars are re-initialized (Using the debug.print command)

(My previous message was trying to use field codes instead of formfields exit sub
Ken
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Legacy Form SYE Word 4 07-26-2019 05:16 AM
How can I set up tab to go back and forth between legacy fields and content control fields in a Word Ikajed Word 1 10-13-2017 06:06 PM
How to tell if a legacy control changed legacy Form Field sunrise06 Word 9 05-02-2015 06:48 PM
How to tell if a legacy control changed Comparing dates in legacy control text box JoeE Word VBA 2 05-08-2013 11:01 PM
Can't open .pst legacy files RetiredEngineer Outlook 1 11-14-2009 01:06 PM

Other Forums: Access Forums

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