Lookup to Radio Button

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a field will a short list of allowable values (from a table). My
user wants the output of the field's contents to show as though a radio
button were selected from the allowable choices.

E.g., if my field's allowable values are "Red", "White" and "Blue", and the
field contained "Blue", the user wants the report to show something like
this:

__ Red __ White _X_ Blue

(forgive the lack of graphical representation of radio buttons, but I think
you get the point).

Ideally, the report wouldn't have to change if a new allowable value was
added to the look up table (e.g., Orange); the report would naturally show
it as an option afterwards:

__ Red __ White _X_ Blue __ Orange
 
I'm not sure how you would get this to work if you added more values but you
could place check boxes with control sources like:
=[MyField]="Red"
=[MyField]="White"
=[MyField]="Blue"
You may need to use code or a multiple column subreport if you want to make
this dynamic.
 
Back
Top