Re: Values stored in fields from Combo Boxes

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Pat Dools (PatDools_at_discussions.microsoft.com)
Date: 12/19/04 

Date: Sun, 19 Dec 2004 07:47:08 -0800

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.

"Jim Moore" wrote:

> In the Data tab, is Bound set to 1?
> Jim Moore
> "Pat Dools" <PatDools@discussions.microsoft.com> wrote in message
> news:B55B439E-73DB-42EC-BFB9-CFBD0E846296@microsoft.com...
> > 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,
> >
> >
> >
> > --
> > Pat Dools
>
>
>

Relevant Pages

  • Re: Bipedal Orrorin?
    ... > No where did Jim claim that his website was problem-free. ... Apes are more bipedal in any depth of water than they are ... Her number TWO reason for bipedality in chimps was moving on ... But now you're just doing what Jim Moore does best. ...
    (sci.anthropology.paleo)
  • Re: Savanna nonsense
    ... Jim McGinn wrote: ... > from the fact that yourself, Jason, MacF, Jim Moore, and ... HAR HAR HAR! ...
    (sci.anthropology.paleo)
  • Re: Using AxSHDocVw.AxWebBrowser control in a form
    ... The problem could be with MS control. ... > place the file in the browser control and the code I use to try to move ... > Jim Brent ... >>> SaBre Document Systems LLC ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Electronics Design on Humongous Monitors
    ... ...Jim Thompson ... security cam pic + voice control soft, middle bottom rxvt terminal with nothing right now, ... And the same PC runs a http, ftp, and mail server, mpeg4 encoder, digital ...
    (sci.electronics.design)
  • Re: frontpage 2003 and .NET
    ... Kevin and Jim, ... Web Matrix is a really cool product. ... >> The Microsoft Press Developer edition books are great. ... >>> Control ...
    (microsoft.public.frontpage.client)