View Single Post
  #2  
Old May 14th, 2010, 06:07 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default combo box fills in arbitrary value

"bicyclops" wrote in message
...
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)