Values stored in fields from Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am using a Combo Box in which I had hoped to show 'male'/'female' on the
Form, but actually store 'm'/'f' in the field in the underlying Table. My
Row Source Type is 'Value List' and my Row Source looks like this:
"f";"female";"m";"male". I have Column 1 ('m'/'f') as the Bound Column.

I had the 'Column Widths' set to 0";0.3" (Column Count of '2'), so the data
entry person wouldn't see the 'm'/'f' values, but if I do that, then
'male'/'female' get stored in the Table, instead of 'm'/'f'. Only if I set
'Column Widths' to 0.1";0.3" (to make Column 1 visible) will it store 'm'/'f'
value. Unfortunately, what the data entry person sees once the Form is saved
is 'm' or 'f' instead of 'male' or 'female'. Is there a way to see 'male' or
'female' on the Form but have 'm' or 'f' stored in the underlying Table? I
thought it was pretty straightforward if I gave the Bound Column a width of
zero, but apparently not.

Thanks,
 
Hi Jim, I verified that the 'Bound' in the 'Data' section of the control
properties is set to '1'. I suppose I could do a Lookup table, but I thought
using a Value List would be a bit simpler.
 
Back
Top