Re: Don't allow select in combo box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sue-Fong (suefong.shen_at_questpharm.com)
Date: 07/20/04


Date: Tue, 20 Jul 2004 16:06:06 -0400

The properties are as follows:

Row Source Type: Table/Query

Row Source: Select [client table].[client name]from [client table];

Column Count: 1

Column Heads: No

Column widths: 1.7077"

Bound Column: 1

List Rows: 8

List Width: 1.7083"

Limit To List: Yes

Auto Expand: Yes

Visible: Yes

Display When: Always

Enabled: Yes

Locked: Yes

Allow AutoCorrect: Yes

Tab Stop: Yes

Tab Index: 1

Left: 4.2"

Top: 0.16"

Width: 1.95"

Height: 0.25"

back Style: Normal

Back Color: -2147483643

....

Blanks on all the Event properties.

Help!

"Kevin Sprinkel" <anonymous@discussions.microsoft.com> wrote in message
news:0b1701c46e7d$9ef63740$a601280a@phx.gbl...
> The Locked property may be set to Yes. If that doesn't
> solve it, please post the values of the other properties
> on the Data tab.
>
> HTH
> Kevin Sprinkel
>
> >-----Original Message-----
> >It is an unbound combo box, it'll display the list but
> when moving the
> >cursor to the list and clicking, it won't select.
> >(It is blank in the Control Source property.)
> >Know why?
> >
> >
> >.
> >



Relevant Pages

  • RE: Display a field only
    ... Set the Locked property of the control to Yes. ... The control will display ... Set the Tab Stop property to No. ...
    (microsoft.public.access.forms)
  • Refresh nested subforms
    ... Display Control: Combo Box ... Row Source Type: Table/Query ... Row Source: SELECT CountryCodes.CountryName FROM CountryCodes ORDER BY ... This field joins the tables using the destination name ...
    (microsoft.public.access.formscoding)
  • RE: Display Yes/No instead of -1, 0 on Search Forms
    ... Row Source Type: Value List ... Bound Column: 1 ... To get Yes/No to display in your query, ... 'Set the WHERE clause for the Listbox RowSource if information has been ...
    (microsoft.public.access.formscoding)
  • Re: =Iff(([Me]![Gender])="M","Male","Female")
    ... does it display an error? ... Out of curiousity, why are you using two text boxes? ... Row Source Type: Value List ... as the value of the Gender field. ...
    (comp.databases.ms-access)