Prev: MouseDown event does not always fire
Next: Creating a Form Desktop Shortcut to ACCDE
From: ghetto_banjo on 11 May 2010 15:06
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 12 May 2010 09:46
you could put it right in a TextBox on the report.
 | 
Pages: 1
Prev: MouseDown event does not always fire
Next: Creating a Form Desktop Shortcut to ACCDE