|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2009, 09:32 PM
posted to microsoft.public.access.forms
|
|||
|
|||
no data in column in combo box
Access03: am baffled in having a combobox based on a table, that for one
column (gender) the data is blank. as a sanity check I made a form off this same table - and the gender data shows... another sanity check I deleted the old combo box and created a new...same result.. 3rd sanity check I built a query, it shows the data - and sourced the combobox on the query - same result... the column is plenty wide (since it is only 1 letter F or M) and is in the middle of several columns (i.e. Last Name, First Name, Gender, DOB) anybody have a suggestion?? 
|
|
#2
October 28th, 2009, 01:03 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
no data in column in combo box
On Tue, 27 Oct 2009 14:32:01 -0700, GBA wrote:
Access03: am baffled in having a combobox based on a table, that for one column (gender) the data is blank. as a sanity check I made a form off this same table - and the gender data shows... another sanity check I deleted the old combo box and created a new...same result.. 3rd sanity check I built a query, it shows the data - and sourced the combobox on the query - same result... the column is plenty wide (since it is only 1 letter F or M) and is in the middle of several columns (i.e. Last Name, First Name, Gender, DOB) anybody have a suggestion?? What version of Access and what service pack level? As I recall there was a bug in the first releases of A2003 that caused combo boxes to blank out; I don't recall the exact circumstances, maybe someone with a better memory will. -- John W. Vinson [MVP]
|
|
#3
October 28th, 2009, 02:39 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
no data in column in combo box
Close, John! It was the SP3 service pack for Acc2003 that really was buggy,
including the 'disappearing data' in comboboxes. Here's a link to the hotfix that resolves the issue: http://support.microsoft.com/kb/945674 -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1
|
|
#4
October 28th, 2009, 05:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
no data in column in combo box
On Wed, 28 Oct 2009 02:39:16 GMT, "Linq Adams via AccessMonster.com"
u28780@uwe wrote: Close, John! It was the SP3 service pack for Acc2003 that really was buggy, including the 'disappearing data' in comboboxes. Here's a link to the hotfix that resolves the issue: http://support.microsoft.com/kb/945674 Thanks Linq! -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
