List Box . ..not showing all value

[5694]

I am populating a list box value from a query. I am only showing the StatusUpdate filed. But only part of the value is displayed on the list box. I want to scroll vertically and see all the value. StatusUpdate is a MEMO field, is that limiting the size. Do I need to use VBA instead of the query? Please help.

Here is my query.
SELECT Status.StatusUpdate, Status.LastUpdateDate, Status.StatusID, Status.ProjectID
FROM Status
WHERE (((Status.LastUpdateDate)=( SELECT max(lastupdatedate)
FROM Status
WHERE Status.ProjectID = [forms]![project]![Text21]))
AND ((Status.ProjectID)=[forms]![project]![Text21]));


Thanks

 

[kimmer7389]

As far as I know you can't have a scroll bar on a field in a list box. You could use a subform instead of a list box if you wanted to have a scroll bar on the field.

The only other solution I know if is to make the field wider in your list box so that it displays more text.