Originally Posted by
dcrake
It appears to me that the guidelines you have mentioned were not originated by yourself. It appears it comes from someone who does not know the in and outs of what Access can achieve and is purely a wish list.
The height and width is governed by the maximum number of rows set to show in a combo box (default is 8) the width is set by the programmer if hard coded unless it attempts to show all columns that do not have a 0 width, and as such may show a horizontal scroll bar. Also it is dependant on its location on the form. If the combo is on the righ of the form then there is not going to be much room to display the results. A good developer will ensure that combo box contents do not protrude outside of the boundaries of a form. If fari to say that if you have 5 fields concatenated together onto one long string it is going to be hard to show the user which charaters in the string match the string entered in first place, unless somehow you could bolden the matching text, which you can't do in Access.
To me this is more a training issue than a technical issue. As the developer I would say to the client, "Yes, I take on board what you say, but due to the limitations of what Access can provide this is the best solution I can offer you."
If I were searching for a part in a parts table I would be looking for a general description.
David