golfinray said:
My combo is not displaying one value when it is not dropped down. That is
what I want it to do. I set list rows to one and it still does not display
unless you drop it.
Do you mean it's blank, even when a value from the list has been selected?
If so, something is wrong. There is a bug that came in with SP3 for Access
2003, that sounds like this problem:
http://support.microsoft.com/kb/945280/
Combo box controls and list box controls display no value or incorrect
values in Access 2003 after you install Office 2003 Service Pack 3
If that's your problem, there's a hotfix for it. Here's the link:
http://support.microsoft.com/kb/945674
Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007
But don't install that hotfix unless you have established that you have
installed Office 2003 SP3, and that the problem described in the first link
is in fact the source of your problem.
Note that, if your combox is bound to a field that has a value that is not
in the combo's list, the combo will be blank. That's a totally different
issue.