 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008Set Column Width
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 > Hi, > [quoted text clipped - 7 lines] > > Thanks 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.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 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 > > Hi, > > [quoted text clipped - 17 lines] > 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. 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. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 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. > > 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 [quoted text clipped - 5 lines] > 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. 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. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thanks Rick, that worked. > > 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 [quoted text clipped - 7 lines] > a Checkbox there "Adjust Column Widths". Whatever you have that currently > set to, try the other setting. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.