PC Review


Reply
Thread Tools Rate Thread

changing option group value to something meaningful

 
 
RipperT
Guest
Posts: n/a
 
      2nd Oct 2005
Hello,

I have an option group on a form that users select tween two choices. The
form says "Male" and "Female", but the values stored in the table are "1"
and "2". In my queries and reports, how can I get the values to show as
"Male" and "Female" again?

Many thanks,

Ripper

--
Ripper T Smith
rippertsmith<nospam>@comcast.net


 
Reply With Quote
 
 
 
 
Rick Brandt
Guest
Posts: n/a
 
      2nd Oct 2005
> Hello,
>
> I have an option group on a form that users select tween two choices.
> The form says "Male" and "Female", but the values stored in the table
> are "1" and "2". In my queries and reports, how can I get the values
> to show as "Male" and "Female" again?
>
> Many thanks,
>
> Ripper


=Choose([FieldName], "Male", "Female")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace microsoft forms message box with something more meaningful Forum Freak Microsoft Excel Programming 4 24th Jul 2008 08:50 PM
Why can't I get a meaningful exception with Activator.CreateInstan =?Utf-8?B?SGFycnkgS2Vjaw==?= Microsoft Dot NET Framework 1 10th Feb 2005 06:10 PM
Copying meaningful data only into new worksheet - VBA Rachel Curran Microsoft Excel Programming 6 24th Sep 2004 01:30 PM
Meaningful error messages from a web service Joshua Ellul Microsoft ASP .NET 0 15th Feb 2004 01:29 AM
Meaningful Error Message Pauline C Microsoft Access Form Coding 2 5th Sep 2003 09:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:26 AM.