Varying column widths in report

T

Ted Telesky

I have an aplication that generates (for the sake of
explaination) lists in columns of file names and file
attricbutes - this is done in a form with a sub form. At
the top of the subform I have buttons that act as the
titles for the columns. When you click a button the list
gets resorted buy that column. What I would like to add
is the ability for the user to change the width of any
column once the form is created - much like an Excel
spreadsheet column. But I cannot see to find any mouse
commands to do that or messages I can pick up from the
mouse position. In other words, how do I know I am at
the end of the button (or coulumn), change the cursor to
a "adjust width" cursor and allow the user to press the
mouse button and vary the width of the button and the
column below it in the subform.
Thanks
Ted
 
E

Elwin

you can't do this with a report. (subject title)

the only way you can do this with a form (msg contents) is
to display it using the datasheet view. Changing
the 'Default View' property of the form to 'datasheet'
will accomplish this. The main drawback to this is that
you can only use text box, check box, and combobox
controls on your form. To modify the column headings you
can attach labels to these controls. I hope this gets you
where you want to go. Good luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top