From: ghetto_banjo on
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.
From: ghetto_banjo on
you could put it right in a TextBox on the report.