Combo Box Wizard
in [Forms]
|
From: Lamar on 23 Apr 2010 18:35 I use the Combo Box Wizard to create a cbo to find a record on my form based on a value I select. My values are Last Name and First Name. However, in the drop-down menu I can not see the values but they are there. So I can select something (I can not see) in the cbo and then the record appears on the form. I have checked font and background and that does not seem to be problem. Any help is appreciated. Thanks Lamar
From: KARL DEWEY on 23 Apr 2010 19:30 Open your form in design view, click on the combo, double click the combo, scroll down and select Properties. In the Properties window select the All tab. Post the information from the following -- Control Source Column Count Column Widths Row Source Row Type Bound Column Someone can analyze the information an advise you how to change it. -- Build a little, test a little. "Lamar" wrote: > I use the Combo Box Wizard to create a cbo to find a record on my form based > on a value I select. My values are Last Name and First Name. > > However, in the drop-down menu I can not see the values but they are there. > So I can select something (I can not see) in the cbo and then the record > appears on the form. I have checked font and background and that does not > seem to be problem. > > Any help is appreciated. > > Thanks Lamar
From: Linq Adams via AccessMonster.com on 25 Apr 2010 20:21 Unfortunately, you've apparently running v2003 and have updated to the SP3 service pack and it's buggier than the Great Dismal Swamp! One of the most common bugs reported involves comboboxes with disappearing data! Sound familiar? The "disappearing" field(s) in the underlying table have some kind of formatting in place. This is often the simple > used to force UpperCase. Remove any formatting from the fields and things should work short term, but the definitive solution is to install the hotfix for SP3. Here's the link for the hotfix: http://support.microsoft.com/kb/945674 -- Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: How To Go From One Form to Another Next: Enabling a control based on multiple criteria |