Charlotte Foust
cfoust at infostatsystems.com
Thu Mar 3 15:45:15 CST 2005
We're trying to find out *why* it's happening so we can prevent it, and the form is shared with the Access version, so an sproc or view is out of the question. The client is in Oklahoma and using a runtime executable, so there isn't any printing to the immediate window. The fact that the dates appear if we remove the Format function from the rowsource strongly suggests that the dates are there but that something is interfering in rendering them. Charlotte Foust -----Original Message----- From: dmcafee at pacbell.net [mailto:dmcafee at pacbell.net] Sent: Thursday, March 03, 2005 11:15 AM To: Access Developers discussion and problem solving Cc: Steve White Subject: RE: [AccessD] AXP Combobox Shows blank formatted date column Have you printed to the immediate window to see if the value is actually in the combo (just not displaying)? What about changing the resource to a view or sproc that formats the number for you? D -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Thursday, March 03, 2005 11:04 AM To: AccessD at databaseadvisors.com Cc: Steve White Subject: [AccessD] AXP Combobox Shows blank formatted date column We have a client installation where certain machines running Windows 2000 are seeing an odd behavior in a combobox that displays two columns, a report number and a medium formatted date. We have not been able to reproduce the behavior here even on Win2k, so I need some ideas. The back end is SQL Server 2000 and the combobox has this for a rowsource: SELECT ReportNo, ReportNo as [Number], Format(ReportDate, "dd-mmm-yy") FROM DailyDrillHdr WHERE ((DailyDrillHdr.WellID=[Forms]![frmDailyRpt]![cboWellID])) Order by ReportNo desc; This works fine when the form opens and a WellID is selected. It breaks when the user brings up a popup form that allows them to select a different WellID and hand that back to the initial form. The initial form obligingly changes the WellID in its Well combobox, which repopulates the subform, and it specifically requeries the report number combobox in the AfterUpdate event of the WellID combobox. At this point, however, on those problem machines, the date column of the report number combo is blank and it doesn't show dates again until the form is closed and reopened. The combobox is being requeried, because the correct report numbers do show up in it, but not the dates associated with them. The really odd part is that if you take the formatting out of the combobox rowsource, the dates show up every time. Has anyone else seen something like this? I know I have, but it's been years ago and I can't remember what caused it! Charlotte Foust Infostat Systems, Inc. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com