A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

combo box fills in arbitrary value



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 14th, 2010, 04:50 PM posted to microsoft.public.access.forms
bicyclops
external usenet poster
 
Posts: 29
Default combo box fills in arbitrary value

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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.