[AccessD] AXP Combobox Shows blank formatted date column

dmcafee at pacbell.net dmcafee at pacbell.net
Thu Mar 3 13:15:05 CST 2005


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




More information about the AccessD mailing list