Option Group values converted to Text String values in reports

  • Thread starter Thread starter Fons Ponsioen
  • Start date Start date
F

Fons Ponsioen

Hi.
I guess you need to conver these for a report or Form?
The easiest may be:
=IIF (OptionValue = 1,"Hardware",IIF(OptionValue =
2,"Software","Other"))
all of this on one line.
Hope this helps.
Fons
-----Original Message-----
I have several option groups in my database that I need
Click to expand...
to convert the stored numeric values to the Text they
represent in the reports I write. Example: Option Value
(1) = Hardware, Option Value (2) = Software, OPtion Value
(3) = Other
 
I placed the line in the control source of the Option Group's field but it only prints out Other. The field's results are only 2 options (Hardware or Software) I used Other in the example in case some of my groups contain more than just 2 options
When I removed the reference to Other from the expression The report printed nothing

I also noticed ther was not an Iff before the Other. I think I'm missing the boat somewhere.
 
The following line is correct.
=IIF (OptionValue = 1,"Hardware",IIF(OptionValue =
2,"Software","Other"))
All on one line.
I suspect that your "OptionValue" may not be a numeric
value but rather a text entry. If so you may want to try:
=IIF (OptionValue = "1","Hardware",IIF(OptionValue =
"2","Software","Other")).
(with quotes around the 1 and the 2 just as shown.
Give this a try.
Hope it helps.
Fons
-----Original Message-----
I placed the line in the control source of the Option
Click to expand...
Group's field but it only prints out Other. The field's
results are only 2 options (Hardware or Software) I used
Other in the example in case some of my groups contain
more than just 2 options.
When I removed the reference to Other from the expression The report printed nothing.

I also noticed ther was not an Iff before the Other. I
Click to expand...
think I'm missing the boat somewhere.
.
Hi.
Click to expand...
I guess you need to conver these for a report or Form?
The easiest may be:
=IIF (OptionValue = 1,"Hardware",IIF(OptionValue =
2,"Software","Other"))
all of this on one line.
Hope this helps.
Fons
-----Original Message-----
I have several option groups in my database that I need
Click to expand...
to convert the stored numeric values to the Text they
represent in the reports I write. Example: Option Value
(1) = Hardware, Option Value (2) = Software, OPtion Value
(3) = Other
 
If the values are consecutive, low numeric values (ie 1,2,3,..) then
consider using the Choose() function
=Choose([FieldValue],"Hardware", "Software", "Other")
 
Back
Top