Replace data in report

[Chris R.]

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

[ruralguy via AccessMonster.com]

Look at the Choose() function.

Chris R. wrote:

>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

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

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1

[Chris R.]

On 20 Mai, 17:35, "ruralguy via AccessMonster.com" <u12102@uwewrote:

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

[ruralguy via AccessMonster.com]

Glad I could help Chris!

Chris R. wrote:

>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

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

Message posted via http://www.accessmonster.com

[fredg]

On Tue, 20 May 2008 09:28:47 -0700 (PDT), Chris R. wrote:

On 20 Mai, 17:35, "ruralguy via AccessMonster.com" <u12102@uwewrote:

>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

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.

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