Can users change list box column sizes in "Form View" mode? (not Design mode)

[Chrisso]

Hi All

I have a list box on a form that shows search results with a number of
columns. I have set the size of these columns to what I think is best
for the data and screen size.

One of my users has asked me if it is possible for him to change the
size of the list box columns whilst in form view mode to suit the data
set he is looking at. He expected to be able to dynamically change the
column sizes similar to the way you can do that in Windows Explorer.
Obviously I dont want my users to go into Design Mode and change the
column sizes through the list box properties.

Is it possible to change the list box column sizes in "Form View"
mode?

Has anyone else encountered and/or solved this problem?

Thanks in advance for any suggestions and/or pointers/links.

Chrisso

 

[David Benyo via AccessMonster.com]

Create a subform to display the same results that are currently being shown
by your listbox. Show the subform in Datasheet view. You'd then have to
create some additional buttons to handle whatever your listbox does when you
select the record.

This is the approach I'd play with, but I'm sure there's another solution.

You could also do some sort of calculation to take the max string length of
each column and re-configure the listbox's columnsize by using a cmd button.
It's not dynamic, but would suit the purpose.

 

[Chrisso]

Thanks for the suggestion David.

I cant use datasheet view for the reason you point out - I need my
user to select a record for further actions.

I have decided to add a preview pane underneath the results list box.
When the user double clicks a row in the list box then the details for
that record are displayed in the preview pane with fields large enough
to see all data.

Chrisso