ComboBox with InputMask not working properly

[RippleJD]

Hi folks,

I've got this strange problem with Access 2000. I have an unbound ComboBox control that will be accepting an 8 character string. The row source is a query containing an 8 character text field. This field is really a series of numbers, some starting with zero (ie 01123400). This ComboBox also contains an InputMask: 99/-9999/-99.

Problem 1: If I type only part of the value (ie 011234) and tab out of the combobox, everything is fine. But, if I type the entire value (01123400), I get "The text you entered isn't an item in the list."

Problem 2: If I have previously selected a value in the combobox and I type a zero (the first character in many of the values), one of two things happen: either the very first value of the combobox is returned, or nothing at all happens. If I type any other number, the combobox works fine.

Any suggestions would be much appreciated.

JD

 

[WildHare]

I think your problem is that combo boxes are not designed for data input - they're designed for data display and selection. I can't for the life of me see why you would want an input mask on a combo box. Try taking the mask off and seeing if it works like you want it to.

Input masks control the original acceptance of data into fields. Your combo is displaying data that's already there. It's a little late for a mask, isn't it?



"Remember, you're unique - just like everyone else"
Feel free to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[RippleJD]

The combo box I am using is for data display and selection. The data are not stored in the table with mask characters, but the user wants the mask characters displayed. When searching for an account number, the user does not want to type in the dashes, but wants them shown automatically as he types; hence a mask is neccessary.