[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