Joined: 05 Mar 2009
Online Status: Offline
Posts: 10
Topic: Boxes "Ticked" depending on numbers in a field Posted: 15 Apr 2011 at 2:38am
Hi all,
To put it simply, I want a report that has several tick box options on it (or boxes that could change colour), depending on what a number is in a field, i'd like certain ones to light up/not light up - is this possible?
For example, if the number in a field was "14241246" Box A, B, and C would tick.
If the number was "48124084" Box A would be unticked, B would tick, C would tick.. and so on. (there are about 20 boxes).
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 15 Apr 2011 at 3:37am
you can put a formula on the object to set is background color based on just about anything.
right click and Format the object, Borders tab, BackGround Color x-2 button.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
