View Single Post
 
Old 11-29-2016, 07:21 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit 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

Sure. If the displayed output is 001, 002, etc., and you want to multiply that by something, you could use a field code like:
{={REF Dropdown1}*5 \# 0}
Unless your dropdown only ever displays numbers, though, you might want something like:
{IF{REF Dropdown1}<> "Select an item" {={REF Dropdown1}*5 \# 0}}
where 'Select an item' is the default text' or, if some of the selections might not be numeric:
{IF{REF Dropdown1}={=0+{REF Dropdown1} \# 0} {={REF Dropdown1}*5 \# 0}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote