Form auto fill based on a different field value.

		Microsoft Office Forums > Microsoft Word > Word
Form auto fill based on a different field value.

FAQ

Thread Tools

Display Modes

#22

09-18-2014, 05:43 AM

macropod

Windows 7 64bit Form auto fill based on a different field value.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

You could change the:
{=RPM+10}
and:
{=RPM-10}
field codes to:
{=(RPM>0)*(RPM-10) \# 0}
and:
{=(RPM>0)*(RPM+10) \# 0}
respectively. This will cause them to display 0s while ever the RPM field is empty. To suppress even the 0s, change the final 0 in each field to:
"0;;"

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MACRO - Insert row based on Form Field Criteria	Elan05	Word VBA	5	04-16-2013 06:39 AM
Nested if field that contains a fill-in field is not prompting for fill-in info	Nccadm	Mail Merge	2	04-02-2013 03:15 AM
Form file timesheet, auto fill date from calander	jkeeney	Word	1	03-21-2012 12:21 AM
Macro to populate a text form field based on dropdown selection	koloa	Word	0	10-20-2011 11:52 AM
How can I fill in form I received in email that used underlines instead of text field	Gail L.	Word	2	05-17-2009 12:38 PM

Other Forums: Access Forums

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