Database Analysis

  • Thread starter Thread starter Skip Bisconer
  • Start date Start date
S

Skip Bisconer

When I run this in my Access it comes up with a box full of suggestions. The
problem I am having is some of the suggestions are longer than the viewing
box and it seems the viewing area size is fixed so that you cannot read all
of the suggestions. For instance I ran this on my queries and most of the
suggestions were to change things in the underlying table so when I select
All or any one of them the the Optimize button is disabled and you cannot get
a printout of the suggestions. Does anyone know of a work-around to this
issue?
 
If you are looking at the table directly, DON'T. Write a query, and use the
query as the data source for a report. Set the comment field's CAN GROW
property to YES. Then, when the comment is longer than the space allocated,
it wraps. Try it out.

If you have a form, make the text entry for the comment field look like a
box (make it larger vertically). Then set the SCROLLBARS property to
VERTICAL. Check that out too.

Have fun.
 
I probably did not make a clear case in my original post. When I run
Tools..Analyze..Performance, a Microsoft Info box pops up with many lines of
possible things to correct to improve the performance of the database. Its
that box that I cannot resize in order to see the entire line of
instructions. I can scroll down but not across. Does this make sense?
 
Back
Top