Lani,
You can do it right on the report. In the control on the report change the control source to =IIF(myoptiongroupcontrol = "1", "Day", "Night") where myoptiongroupcontrol is the name of your option group.
Doyce
--- In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Lani
Can you link the field to a lookup table and display the 'description' in the report rather than the 'key value'?
73
Charlie
www.G4EST.me.uk
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mahinalanibaker@...
Sent: 12 September 2013 16:39
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Can you change the value of an option group?
Is it possible to change the value so on a report it doesn't read 1 or 2, instead it reads day or night for example? I tried going into the wizard and changing it when it gives you the numeric value but it won't let me. Has anyone done this before? Or is this just not possible?
Thanks,
Lani B.
Access Dummy
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar