D
dsppmp
How do I change the column width in a report?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Go into design view and then go to the page setup. Use the "columns" tab.
Rick B
Rick B
C
Charles
Open the report in Design View and make your changes from there. Change to
Form View to preview your changes. Save them when you're happy with them.
Charles
Form View to preview your changes. Save them when you're happy with them.
Charles
D
dsppmp
I should have said, "how do I change each column individually in a report?"
I have been able to change all columns to be the same width, but I'd like to
have some columns narrower and some wider. Is there a way to do this?
I have been able to change all columns to be the same width, but I'd like to
have some columns narrower and some wider. Is there a way to do this?
R
Rick B
I doubt it. Not if you are truly producing a column-type report. Each
column will contain the same data so it would typically not make sense to
have them different sizes.
Rick B
column will contain the same data so it would typically not make sense to
have them different sizes.
Rick B
C
Charles
If you're trying to change Column A to one width and Column B to another, you
can accomplish this in design view. It's similar to changing text box and
picture sizes in the other Office products.
1. Click on the the item you want to change the size of. You should see
the border of the placeholder change to one with little boxes on it. Move
your curser onto the square on the side/corner you want to extend/contract.
2. Click-and-drag until you get a size you're happy with. This may require
that you switch back and forth to form view a few times until you tweak it to
the size you want.
3. Make sure you move the column labels so they line up the way you want
them to with the column they represent.
4. Switch to form view one final time to make sure it's what you want and
save the changes.
I generally create a copy of the file and use it to test all my changes
before I copy them over to the original file, just in case.
Charles
can accomplish this in design view. It's similar to changing text box and
picture sizes in the other Office products.
1. Click on the the item you want to change the size of. You should see
the border of the placeholder change to one with little boxes on it. Move
your curser onto the square on the side/corner you want to extend/contract.
2. Click-and-drag until you get a size you're happy with. This may require
that you switch back and forth to form view a few times until you tweak it to
the size you want.
3. Make sure you move the column labels so they line up the way you want
them to with the column they represent.
4. Switch to form view one final time to make sure it's what you want and
save the changes.
I generally create a copy of the file and use it to test all my changes
before I copy them over to the original file, just in case.
Charles
R
Rick B
We are talking about two different things here. Is this a report with
COLUMNS or is it a report with multiple fields spread across the page?
Report Columns are used to "wrap" text to the next column when the bottom of
the page is reached. If you are talking about that, then I think they must
all be equal.
If you simply have multiple fields across the page with record listed down
the page, then you would simply change the size of each field as Charles
points out. By using the term "columns" you imply that this is not the
case.
Rick B
COLUMNS or is it a report with multiple fields spread across the page?
Report Columns are used to "wrap" text to the next column when the bottom of
the page is reached. If you are talking about that, then I think they must
all be equal.
If you simply have multiple fields across the page with record listed down
the page, then you would simply change the size of each field as Charles
points out. By using the term "columns" you imply that this is not the
case.
Rick B
C
Charles
I'm assuming he's talking about the Column A and Column B example I gave, but
you're right we could be talking about two different things. I'm not sure of
what you're referring to but I'm only now beginning to get past the point
where I'm no longer an Access "newbie" and haven't encountered the issue
you're discussing. Either way, I hope one of us was successful in helping
dsppmp. Access is very useful but can be hard to figure out sometimes.
Charles
you're right we could be talking about two different things. I'm not sure of
what you're referring to but I'm only now beginning to get past the point
where I'm no longer an Access "newbie" and haven't encountered the issue
you're discussing. Either way, I hope one of us was successful in helping
dsppmp. Access is very useful but can be hard to figure out sometimes.
Charles
R
Rick B
I agree.
Check out columns when you get time. They are very useful.
A good example is out department phone list. The detail section has the
persons name and extension. If we just built a report it would list on
three pages. Using columns, the data will wrap around the page and fit on
one sheet.
Very useful for certain types of reports.
Rick B
Check out columns when you get time. They are very useful.
A good example is out department phone list. The detail section has the
persons name and extension. If we just built a report it would list on
three pages. Using columns, the data will wrap around the page and fit on
one sheet.
Very useful for certain types of reports.
Rick B