Field Form

[dave117]

Hello,
I am new to access 2007, and need to do the following
I have created a form and in there is a selection of check boxes.
Simply put for gender if they are male check here felame check here trans-
here etc.
I am trying to generate a report that lists by the id number as a text string
but I am getting out the option field output number 1, 2, 3, 4 etc
How do I get this to be the text value, not the field output number
Please keep it simple as I am new!!
thanks

 

[ghetto_banjo]

Well, I believe Option Groups always store numeric values like that,
so there are 2 choices that come to mind.

In your query (or report), use nested if statements like:

if([gender] = 1, "Male", if([gender] = 2 "female", "trans"))


Or you could create a table with 2 fields that has the relationship of
Numeric Values and Genders and then link to that table in the query.

 

[dave117]

dave117 wrote on 05/11/2010 14:34 ET :

Hello,
I am new to access 2007, and need to do the following
I have created a form and in there is a selection of check boxes.
Simply put for gender if they are male check here felame check here trans-m
here etc.
I am trying to generate a report that lists by the id number as a tex string,
but I am getting out the option field output number 1, 2, 3, 4 etc
How do I get this to be the text value, not the field output number
Please keep it simple as I am new!!
thanks

where do I put the function ?

 

[ghetto_banjo]

you could put it right in a TextBox on the report.