Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone tell me if it is possible to limit the contents of a list box to only display a sebset of values in a given field?
e.g I have a field containing 'year' which maybe contain values from 2001 through 2012. I wish to select from these in a list box - but rather than displaying the full 12 year range in the list box - I only want to display a choice of 2010, 2011,2012 ?
Thank You,
You can use a field expression (at the very bottom of the field list in general tab of the list box properties, choose <expression>) and enter:
=if(year>=2010,year)
You can use a field expression (at the very bottom of the field list in general tab of the list box properties, choose <expression>) and enter:
=if(year>=2010,year)
Perfect. Tks v much