[AccessD] List Box does not show all

So if you paste that SQL into a query, you get a different number of row
than what shows in the combo?

Charlotte Foust

-----Original Message-----
From: Gregg [mailto:greggs at msn.com] 
Sent: Tuesday, April 27, 2004 9:13 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] List Box does not show all


Susan,

It's a table... here's the source...

SELECT DISTINCTROW [PLastName]+", "+[PFirstName] AS PatientName,
PatientTbl.Address, PatientTbl.City, PatientTbl.Zip, PatientTbl.Phone,
PatientTbl.AdmittingNurse,
DateDiff("h",Format([ReferralDate],"mm/dd/yy") & " " &
Format([HourOfReferal],"hh:nn:ss"),Format(Now(),"mm/dd/yy hh:nn:ss")) AS
HoursSinceReferral, PatientTbl.PatientID FROM PatientTbl WHERE
((([PLastName]+", "+[PFirstName]) Is Not Null) AND
((PatientTbl.DenialReason) Is Null) AND ((PatientTbl.dateServiceStart)
Is Null));





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Tuesday, April 27, 2004 9:23 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] List Box does not show all


Where are the list items coming from? Sounds like you're using a
Table/Query list, so this wouldn't be the problem, but a Value list is
limited in the number of characters, and with 7 columns, you might have
reached it -- if you're using a Value list.

Susan H.

The list box is trying to display 36 rows but only shows 23.  The query
behind the list is showing 36.  It's seven columns wide.  I thinks all
users are using the same version of A97.

--
_______________________________________________
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