From: bicyclops on 14 May 2010 11:50 A combo box on a form selects from a list of codes (001, 015, 400, 411, 500 etc). These are formatted as text with an input mask of 000. The Row Source is a simple Select statement that draws from a table. When you start typing the first character in this box, Access auto fills after the cursor with the value '411'. So if I type 0, the value is 0411, which is not even a valid code. Even if you type 4 as the first character it auto fills with 4411. Doesn't seem to make any sense. I've tried changing every combo box property (I think) including those having to do with defaults. Nothing seems to change this behavior. I use many combo boxes, and only a few have behaved like this; I can't figure out why.
From: Dirk Goldgar on 14 May 2010 13:07 "bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message news:BE6594AB-A947-4FAC-A0C9-0F56AA03FC64(a)microsoft.com... >A combo box on a form selects from a list of codes (001, 015, 400, 411, 500 > etc). These are formatted as text with an input mask of 000. The Row > Source > is a simple Select statement that draws from a table. > > When you start typing the first character in this box, Access auto fills > after the cursor with the value '411'. So if I type 0, the value is 0411, > which is not even a valid code. Even if you type 4 as the first character > it > auto fills with 4411. Doesn't seem to make any sense. I've tried changing > every combo box property (I think) including those having to do with > defaults. Nothing seems to change this behavior. > > I use many combo boxes, and only a few have behaved like this; I can't > figure out why. That sounds odd. Please post the following properties of the combo box: 1. Row Source 2. Bound Column 3. Control Source 4. Default Value 5. Column Count 6. Column Widths 7. Format Also, if there is code or macros applied to any of the events of the combo box, post the details of that. Since you say the combo box's rowsource is a SELECT statement, please post the names and types of the fields in the table from which that statement selects. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup)
From: bicyclops on 14 May 2010 14:02 Dirk - answers below. Row Source: SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix, TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY TblPartPrefix.PartPrefix; Bound Column:1 Control Source: PartPrefixID Default Value: blank Column Count: 3 column Widths: 0";0.5";2" Format: blank Thanks for looking into it! "Dirk Goldgar" wrote: > "bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message > news:BE6594AB-A947-4FAC-A0C9-0F56AA03FC64(a)microsoft.com... > >A combo box on a form selects from a list of codes (001, 015, 400, 411, 500 > > etc). These are formatted as text with an input mask of 000. The Row > > Source > > is a simple Select statement that draws from a table. > > > > When you start typing the first character in this box, Access auto fills > > after the cursor with the value '411'. So if I type 0, the value is 0411, > > which is not even a valid code. Even if you type 4 as the first character > > it > > auto fills with 4411. Doesn't seem to make any sense. I've tried changing > > every combo box property (I think) including those having to do with > > defaults. Nothing seems to change this behavior. > > > > I use many combo boxes, and only a few have behaved like this; I can't > > figure out why. > > > That sounds odd. Please post the following properties of the combo box: > > 1. Row Source > 2. Bound Column > 3. Control Source > 4. Default Value > 5. Column Count > 6. Column Widths > 7. Format > > Also, if there is code or macros applied to any of the events of the combo > box, post the details of that. > > Since you say the combo box's rowsource is a SELECT statement, please post > the names and types of the fields in the table from which that statement > selects. > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) >
From: Dirk Goldgar on 14 May 2010 14:59 "bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message news:BDA8C7D8-0119-49C1-9B8B-37FF19764BF3(a)microsoft.com... > Dirk - answers below. > > Row Source: > SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix, > TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY > TblPartPrefix.PartPrefix; > > Bound Column:1 > Control Source: PartPrefixID > Default Value: blank > Column Count: 3 > column Widths: 0";0.5";2" > Format: blank > > Thanks for looking into it! Could you give me a few sample rows from TblPartPrefix? There aren't any rows with the same PartPrefixID, are there? What type of data are PartPrefixID and [Prefix Description]? -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup)
From: bicyclops on 14 May 2010 16:05 Samples: PartPrefixID Part Type (Prefix) Prefix Description 1 001 CAD 2 400 Assembly 3 500 High-Level Assembly 4 998 Unknown 5 011 IC, Through Hole, Programmed 6 260 Stencil 7 350 Misc. Assembly 8 410 Flash Card Kit 9 411 EPROM Kit 10 999 Generics The data types are Autonumber, Text & Text "Dirk Goldgar" wrote: > "bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message > news:BDA8C7D8-0119-49C1-9B8B-37FF19764BF3(a)microsoft.com... > > Dirk - answers below. > > > > Row Source: > > SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix, > > TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY > > TblPartPrefix.PartPrefix; > > > > Bound Column:1 > > Control Source: PartPrefixID > > Default Value: blank > > Column Count: 3 > > column Widths: 0";0.5";2" > > Format: blank > > > > Thanks for looking into it! > > Could you give me a few sample rows from TblPartPrefix? There aren't any > rows with the same PartPrefixID, are there? What type of data are > PartPrefixID and [Prefix Description]? > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) >
|
Next
|
Last
Pages: 1 2 Prev: Order By/Filter clause corrupted with aliases Next: How to run event on other options |