Tables - Format/ColumnWidth/BestFit

[JethroUK©]

Why doesn't this work?

or is there a special technique?

Office2K

 

[Gary Miller]

Jethro,

It doesn't work because tables are designed to hold data,
not to display it. Forms and Reports are the data display
tools Access gives you and are very flexible in formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[JethroUK©]

"...It doesn't work because tables are designed to hold data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically] designed for Tables/Queries
(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont understand

 

[Gary Miller]

You need to select the Column that you want to apply it to
or multiselect all of the columns to apply it to all of them
at once. Works for me.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

"...It doesn't work because tables are designed to hold data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically] designed for Tables/Queries
(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont understand

Jethro,

It doesn't work because tables are designed to hold data,
not to display it. Forms and Reports are the data display
tools Access gives you and are very flexible in formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
news:[email protected]...

 

[JethroUK©]

Tried that - it doesn't work correctly (it crops some fields?) - i assume it
suposed to 'best fit' both the column heading and the column contents

my sample has about a hundred records (not exactly taxing )

selecting 'best fit' from the menu and double-clicking the column sizers
gives 2 different results (neither of which are right (

i think they just put best-fit option in for fun (must make some abitrary
guess) - not lot fun when students use it in exams though & fail it for
cropped data

thanx anyhow

You need to select the Column that you want to apply it to
or multiselect all of the columns to apply it to all of them
at once. Works for me.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

"...It doesn't work because tables are designed to hold data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically] designed for Tables/Queries
(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont understand

Jethro,

It doesn't work because tables are designed to hold data,
not to display it. Forms and Reports are the data display
tools Access gives you and are very flexible in formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
Why doesn't this work?

or is there a special technique?

Office2K

 

[Gary Miller]

Jethro,

I did get the same slight cropping when I did them as a
group, however when I do them individually they seem to
correct themselves.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Tried that - it doesn't work correctly (it crops some fields?) - i assume it
suposed to 'best fit' both the column heading and the column contents

my sample has about a hundred records (not exactly taxing )

selecting 'best fit' from the menu and double-clicking the column sizers
gives 2 different results (neither of which are right (

i think they just put best-fit option in for fun (must make some abitrary
guess) - not lot fun when students use it in exams though & fail it for
cropped data

thanx anyhow

You need to select the Column that you want to apply it to
or multiselect all of the columns to apply it to all of them
at once. Works for me.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
news:[email protected]...

"...It doesn't work because tables are designed to

hold
data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically] designed

for
Tables/Queries

(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont understand


Jethro,

It doesn't work because tables are designed to hold data,
not to display it. Forms and Reports are the data display
tools Access gives you and are very flexible in formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

news:[email protected]...

Why doesn't this work?

or is there a special technique?

Office2K

 

[JethroUK©]

i have to teach a distinct method for speed and accuracy, such that my
students can retain it for exam

i think they will need to size each column/field individually as you've
found (but it has a time overhead for exam - hey ho )

Jethro,

I did get the same slight cropping when I did them as a
group, however when I do them individually they seem to
correct themselves.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Tried that - it doesn't work correctly (it crops some fields?) - i assume it
suposed to 'best fit' both the column heading and the column contents

my sample has about a hundred records (not exactly taxing )

selecting 'best fit' from the menu and double-clicking the column sizers
gives 2 different results (neither of which are right (

i think they just put best-fit option in for fun (must make some abitrary
guess) - not lot fun when students use it in exams though & fail it for
cropped data

thanx anyhow

You need to select the Column that you want to apply it to
or multiselect all of the columns to apply it to all of them
at once. Works for me.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
"...It doesn't work because tables are designed to hold
data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically] designed for
Tables/Queries
(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont understand


message
Jethro,

It doesn't work because tables are designed to hold
data,
not to display it. Forms and Reports are the data
display
tools Access gives you and are very flexible in
formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Why doesn't this work?

or is there a special technique?

Office2K

 

[Rick Brandt]

i have to teach a distinct method for speed and accuracy, such that my
students can retain it for exam

Why on earth would an exam include questions on doing something like this? It
has absolutely nothing to do with the proper use of Access to develop useful
applications. What datasheet views "look like" is a completely insignificant
piece of minutia since no mature application even exposes the datasheets to the
user. It's only marginally better than including in the exam the steps for
finding "easter eggs".

Beyond that, are you aware that the "best fit" feature in Access only concerns
itself with the currently displayed rows of data? If rows further down take
more horizontal space the feature will not make the column wide enough for those
rows.

 

[Gary Miller]

I agree with Rick that, if you are teaching this, you are
teaching fairly useless and pretty questionable practices.
Like I said in my first post, you should not be using tables
for data display purposes and certainly not teaching the
practice. In addition, I would think that the accuracy,
proper procedures and design concepts would be much more
important than speed for an exam.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

i have to teach a distinct method for speed and accuracy, such that my
students can retain it for exam

i think they will need to size each column/field individually as you've
found (but it has a time overhead for exam - hey ho )

Jethro,

I did get the same slight cropping when I did them as a
group, however when I do them individually they seem to
correct themselves.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
news:[email protected]...

Tried that - it doesn't work correctly (it crops some fields?) - i assume it
suposed to 'best fit' both the column heading and the column contents

my sample has about a hundred records (not exactly

taxing
)

selecting 'best fit' from the menu and double-clicking

the
column sizers

gives 2 different results (neither of which are right (

i think they just put best-fit option in for fun (must make some abitrary
guess) - not lot fun when students use it in exams

though
& fail it for

cropped data

thanx anyhow


You need to select the Column that you want to apply

it
to

or multiselect all of the columns to apply it to all

of
them

at once. Works for me.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

news:[email protected]...

"...It doesn't work because tables are designed to hold
data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically]

designed
for

Tables/Queries
(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont understand


message
Jethro,

It doesn't work because tables are designed to hold
data,
not to display it. Forms and Reports are the data
display
tools Access gives you and are very flexible in
formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

news:[email protected]...

Why doesn't this work?

or is there a special technique?

Office2K

 

[JethroUK©]

Why on earth would an exam include questions on doing something like this? It
has absolutely nothing to do with the proper use of Access to develop useful
applications. What datasheet views "look like" is a completely insignificant
piece of minutia since no mature application even exposes the datasheets to the
user. It's only marginally better than including in the exam the steps for
finding "easter eggs".

Beyond that, are you aware that the "best fit" feature in Access only concerns
itself with the currently displayed rows of data? If rows further down take
more horizontal space the feature will not make the column wide enough for those
rows.

and there behangs the problem, and explains why it's unreliable - the exam
doesn't include a question like this - the exam expects them to import data
to tables, edit the records, include extra fields, delete some fields,
produce several queries, produce several calculated fields and build/edit 5
reports - but after building one of the queries they just need an
'uncropped' print so i was hoping they could save time on this question
(rather than build a 6th report)

 

[JethroUK©]

"...I would think that the accuracy, proper procedures and design concepts
would be much more important than speed for an exam...."

They have 3 hours - no more, so time is not an option

I agree with Rick that, if you are teaching this, you are
teaching fairly useless and pretty questionable practices.
Like I said in my first post, you should not be using tables
for data display purposes and certainly not teaching the
practice. In addition, I would think that the accuracy,
proper procedures and design concepts would be much more
important than speed for an exam.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

i have to teach a distinct method for speed and accuracy, such that my
students can retain it for exam

i think they will need to size each column/field individually as you've
found (but it has a time overhead for exam - hey ho )

Jethro,

I did get the same slight cropping when I did them as a
group, however when I do them individually they seem to
correct themselves.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
Tried that - it doesn't work correctly (it crops some
fields?) - i assume it
suposed to 'best fit' both the column heading and the
column contents

my sample has about a hundred records (not exactly taxing
)

selecting 'best fit' from the menu and double-clicking the
column sizers
gives 2 different results (neither of which are right (

i think they just put best-fit option in for fun (must
make some abitrary
guess) - not lot fun when students use it in exams though
& fail it for
cropped data

thanx anyhow


message
You need to select the Column that you want to apply it
to
or multiselect all of the columns to apply it to all of
them
at once. Works for me.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

"...It doesn't work because tables are designed to
hold
data..."

thanx but that's not the answer

Format/ColumnWidth/BestFit is [specifically] designed
for
Tables/Queries
(there is no "Best fit" methods for forms/reports)

So my question remains - why dont it work ?

Maybe there is some special technique i dont
understand


message
Jethro,

It doesn't work because tables are designed to hold
data,
not to display it. Forms and Reports are the data
display
tools Access gives you and are very flexible in
formatting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________


Why doesn't this work?

or is there a special technique?

Office2K