Replace data in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris R. - 20 May 2008 16:13 GMT

Hi,

I save radio button information as number in my database
1 = blue
2 = red
3 = yellow

In my report, I would like to display the colours instead of numbers.
How to do this?

thanks
chris

Reply to this Message

ruralguy - 20 May 2008 16:35 GMT

Look at the Choose() function.

>Hi,
>
[quoted text clipped - 8 lines]
>thanks
>chris

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Chris R. - 20 May 2008 17:28 GMT

> Look at the Choose() function.

thanks. In German it is called wahl() but that was exactly I'm looking
for.

=wahl([fieldname];"red";"blue";"yellow")

greetz
chris

Reply to this Message

ruralguy - 20 May 2008 17:42 GMT

Glad I could help Chris!

>> Look at the Choose() function.
>
[quoted text clipped - 5 lines]
>greetz
>chris

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

fredg - 20 May 2008 17:44 GMT

>> Look at the Choose() function.
>
[quoted text clipped - 5 lines]
> greetz
> chris

Choose() is good!

Just for your general information .... in addition to using Choose(),
you could also have used IIf().

=IIF([OptionValue] = 1,"red",IIf([OptionValue]= 2,"blue","yellow"))

and if you have lots of options, Select Case in VBA code.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message