default display in dropdown?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shell - 13 Apr 2008 20:12 GMT

I have a dropdown in a access 07 Form which has a list of States.

I would like tjhe state of Washington to be the default state showing, yet
allowing the user to click the dropdown arrow to select another state. I
tried the Default option and typed 'Washington' in properties, but it doesn't
display it.

Is there a way?

Reply to this Message

Peter Schultz - 13 Apr 2008 20:25 GMT

>I have a dropdown in a access 07 Form which has a list of States.
>
[quoted text clipped - 5 lines]
>
> Is there a way?

AAAAA

Reply to this Message

Shell - 13 Apr 2008 20:45 GMT

Peter - are you rateing my question? :) I've no idea what "AAAAA" means.

> >I have a dropdown in a access 07 Form which has a list of States.
> >
[quoted text clipped - 6 lines]
> > Is there a way?
> AAAAA

Reply to this Message

Rick Brandt - 13 Apr 2008 20:49 GMT

> I have a dropdown in a access 07 Form which has a list of States.
>
[quoted text clipped - 4 lines]
>
> Is there a way?

Does your control display one column while holding the value of another? If
so the DefaultValue property must be for the bound column, not the displayed
one. Otherwise what you did should work.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message