retaining column widths

[Peter]

I am using MS Office 2000 Professional
Can anyone advise please - I create a report and set all column widths to
suit content and page layout. I then save the database, but when I return
and open the database next time all the columns widths have changed - I then
have to manualy adjust them all again before I can print as required. How
can I prevent these widths being changed? And WHY do they change?!

 

[Joseph Meehan]

I am using MS Office 2000 Professional
Can anyone advise please - I create a report and set all column
widths to suit content and page layout. I then save the database, but
when I return and open the database next time all the columns widths
have changed - I then have to manualy adjust them all again before I
can print as required. How can I prevent these widths being changed?
And WHY do they change?!

Are you setting the column widths where; table, query, form report?

You likely should be using a report and assuming you save the report it
will stay. If you are using a table, you are way off, tables are just for
holding the data and designing the table and nothing more.

 

[Peter]

Are you setting the column widths where; table, query, form report?

You likely should be using a report and assuming you save the report it
will stay. If you are using a table, you are way off, tables are just for
holding the data and designing the table and nothing more.

I am setting widths in form report and saving...but they do NOT stay the
same whenI reopen

 

[Guest]

Ensure that your database is not residing in a read only folder / drive. If
not, you can try queries too. Forms and reports should also work.

 

[Joseph Meehan]

I am setting widths in form report and saving...but they do NOT stay
the same whenI reopen

Then I go to the fall back position. Are you sure the file is not read
only and that you have full access the the location where the file is
located and an access level to the file that allows changes in design?

 

[Peter]

Then I go to the fall back position. Are you sure the file is not read
only and that you have full access the the location where the file is
located and an access level to the file that allows changes in design?

I have full access to the file - it is my own program on my own personal
computer..no other person has access to, or uses the computer. The file is
not read only - in fact I am changing the design and layout frequently and
printing reports with no problem. It is only after saving the file, shutting
down the program and restarting later that the column widths are changed.

 

[Peter]

The database is stored in My Documents folder on my own computer. It is a
personal database of my music collection. It is not read only. No other
person even has access to my house, far less to my computer! All other
changes I am making are retained with no problem..it is ONLY the column
widths in the reports that are changing

 

[Rick Brandt]

The database is stored in My Documents folder on my own computer. It
is a personal database of my music collection. It is not read only.
No other person even has access to my house, far less to my computer!
All other changes I am making are retained with no problem..it is
ONLY the column widths in the reports that are changing

And you are quite sure that this is a *report* and not a query or table that you
are printing? While the latter have a Page Setup that you can bring up it is
not saved between instances.

 

[Peter]

Most definitely I am referring to Reports - as created by myself. Not List
view, Form, Query, Table or anything else. And I am not refering to problems
using page set-up. If I go select a Report,Selct Modify, I can then change
column widths of the report to suit my contents and page size and layout.
However..these columns widths are not necessarily retained after I save the
database, and then reopen it.

 

[tina]

try turning off Name AutoCorrect in your database, if it's not already
turned off. from the database window's menu bar, click Tools | Options |
General tab. uncheck the box next to Track name AutoCorrect info.

if that doesn't help, please specify where you're clicking on Modify
(shortcut menu, menu bar, submenu, etc), and what view you're in at the time
(report preview, design view, database window, etc). i haven't been able to
locate it.

hth

 

[Peter]

I can only use may old age as an excuse! Have only just realised that I'm
not even using MS Access for my database....although I have Access, I am
using MS Works 7 !!
Ok - so shoot me - put the old man out of his misery.
What can I say..this is SOOOO embarrassing!
However, when all is said I still have the same problem....but in Works
database (*.mdf file) rather than Access.

 

[Arvin Meyer]

I am going to go for the obvious. Feel free to throw rocks if I'm off base.
You can only make changes in a report while the report is in Design View.
That means opening it that way, from a form. The code running from a form
should look something like this:

DoCmd.OpenReport "ReportName", acViewDesign
' Call Your column change code
DoCmd.Close acReport, "ReportName", acSaveYes

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joan Wild]

Don't sweat it Peter. You will likely get better helpif you post to a
newsgroup for Works like
microsoft.public.works.win

Good luck,

 

[tina]

LOL - i wondered why i couldn't find a Modify option on any menu! <g>
not to worry, Peter, you're not nearly the only person to make that sort of
mistake. i once called my bank and yelled at CS because i couldn't access my
account on the computer - only to find that i was trying to pull up an
account number from the wrong bank. <g and shrug>

 

[Charlie Hoffpauir]

I can only use may old age as an excuse! Have only just realised that I'm
not even using MS Access for my database....although I have Access, I am
using MS Works 7 !!
Ok - so shoot me - put the old man out of his misery.
What can I say..this is SOOOO embarrassing!
However, when all is said I still have the same problem....but in Works
database (*.mdf file) rather than Access.

Your best option is probably to open your database in works, and
either save it as a dBase IV database (or as a CSV file) and then open
Access and import that database into Access. (Access won't directly
read a Works database, but will import either a *.dbf or *.csv file).

You probably won't have the same problem in Access, but if you do, ask
back here and someone can help.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[wuzhangwu126]

I am setting widths in form report and saving...but they do NOT stay the
same whenI reopen