View Single Post
 
Old 05-19-2020, 07:31 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Three issues:
1. Your formula fields lack the required space between 'REF' and 'Dropdown' (e.g. you have 'REFDropdown1' instead of 'REF Dropdown1');
2. You have employed typed braces (i.e. { }) instead of inserting field braces via Ctrl-F9, as a result of which you've also failed to maintained the required pairing (e.g. {= { REFDropdown1} +{REFDropdown2} +/#0} } instead of {= { REF Dropdown1} +{REF Dropdown2} \# 0}); and
3. You've messed up the numeric picture switch (e.g. +/#0 instead of \# 0)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote