Set Column Width

  • Thread starter Thread starter Leanne
  • Start date Start date
L

Leanne

Hi,

How do you set the column width in a query result.

I have been into Format - Column Width and changed it and then saved but
when I refresh it still goes back to standard which makes the result look
horrible because nothing fits in the cells correctly.

Please can someone help as I am fairly new to queries.

Thanks
 
Leanne said:
Hi,

How do you set the column width in a query result.

I have been into Format - Column Width and changed it and then saved
but when I refresh it still goes back to standard which makes the
result look horrible because nothing fits in the cells correctly.

Please can someone help as I am fairly new to queries.

Thanks
Click to expand...

Normally one would not use a table or a query for presentation so the
ability to control things is rather limited. You really should be using a
form or report to show the data.

That being said, queries DO remember a lot more about their on-screen
metrics than tables do. I generally find that I can set the size, and
position of a query datasheet and then save the query and those settings
will be remembered thereafter. I honestly have never noticed if column
widths fall into that same category though.
 
Being fairly new to MSQueries I am not sure which is the best way. However I
am not using Access to display the results I am using Excel. I do not need
the data to be printed or anything like that just want it presentable on the
screen for the user to view. I will give the formating another go and see if
I can't get it to stick.

Thanks
 
Leanne said:
Being fairly new to MSQueries I am not sure which is the best way.
However I am not using Access to display the results I am using
Excel. I do not need the data to be printed or anything like that
just want it presentable on the screen for the user to view. I will
give the formating another go and see if I can't get it to stick.
Click to expand...

If you are looking at the results in Excel then you would have to use Excel
to set the column widths. The formatting of your Access query has little to
do with what you will see in Excel.
 
Yes I have tried this to but do not know how to fix the width of the columns
so they do not change. This is why I tried to do it from the query as the
columns change each time I refresh the query.
 
Leanne said:
Yes I have tried this to but do not know how to fix the width of the
columns so they do not change. This is why I tried to do it from the
query as the columns change each time I refresh the query.
Click to expand...

If you right-click in your Excel range where the results are displayed you
should see a menu option for "Data Range Properties". Choosing that should
open a dialog.

One section of the dialog is labeled "Data formatting and layout". There is
a Checkbox there "Adjust Column Widths". Whatever you have that currently
set to, try the other setting.
 
Thanks Rick, that worked.

Rick Brandt said:
If you right-click in your Excel range where the results are displayed you
should see a menu option for "Data Range Properties". Choosing that should
open a dialog.

One section of the dialog is labeled "Data formatting and layout". There is
a Checkbox there "Adjust Column Widths". Whatever you have that currently
set to, try the other setting.
Click to expand...
 
Back
Top