Recent content by lockjaw4829

DevastatioN - Thank you for saving my hair. I followed the link provided by notification of your post right to the solution to my problem. It appears that once you install MS Office 2003 SP3 this anomaly with combo boxes and/or list boxes using formatting is not the only problem that...

Ok DevastatioN, Here goes. First remember this was origninally a simple text box and the input mask was just a carryove (I do want to retain if in case a user wants to add a new Case Type to the list, but that is for after I get the basic lookup function of the combo box working). Anyway...

Chris - I've posted what I believe to be the relevant data and a screen shot of the form showing the dropped down empty combo box in a seperate post to this thread. If you'd like anything else, please ask and I'll try to provide it. Any suggestions would be greatly appreciated. George

Gemma, All of the values are Text (the control field, the SQL field backing the combo box and the combo box itself). I have posted the relevant data in a recent post including a screen shot showing the offending control. I have tried totally removing the control and recreating it with the...

Ok. first here are the combo box properties from the Data Tab: Control Source: fldCMCaseType Input Mask: >&&&&CCCCCCCCCCCCCCCC;1;" " Row Source Type: Table/Query Row Source: SELECT qryCaseTypes.fldCaseType FROM qryCaseTypes ORDER BY qryCaseTypes.fldCaseType; (Which produces the following...

Tried this, although I was under the impression that setting the bound column to zero caused the ListIndex to be utilized for the data value of the combo box. Didn't work and as a kicker the value for existing records does not display at all in the combo box. Thanks for the thought, I had...

Crazy or not I tried your suggestion. The SQL does indeed reorder itself, yet the combo box on the form remains as before. Thanks for your suggestion, though.

Thank you for at least letting me know that I do know what I'm doing (most of the time, that is). Yep, did the steps just like in the videos, but my result was as described in my original post. Trying to post the form, queries and tables even in a cut down form would be extremely time...

I'm using Access 2003 and on an existing form I'm trying to convet a text box to a combo box. I used the "Convert To" function by right clicking on the text box and selecting combo box. The control changed and looks fine. I left the Control Source as it was and created a SQL in the Row Source...