Store text not number in Option Group

[bdm1]

In Access 2007, I have an option group bound to a field in a table. When user makes a choice, what is recorded in the field is the Option Value number. How do i get it to store the Text Value.

Thanks

 

[dhookom]

You don't. Option groups return a numeric value. Typically you would use a small lookup table with a numeric primary key and a field with the text.

Duane
Hook'D on Access
MS Access MVP