Queries that are "too wide"

[Guest]

I'm looking for advice on how to handle queries that are too wide to fit on
your computer screen. I have too many fields, a couple of which are extremely
wide themselves. Unfortunately, I need to be able to see everything at
once...scrolling back and forth is not a logical option for my purposes.

Any suggestions would be great.

 

[PC Datasheet]

Use a tab control. Place the number of fields that fits on a tab page and
use the number of tab pages that it takes to display all your fields. The
tabcontrol is found in the toolbox.

 

[Allen Browne]

You do realize you can adjust the Height of the row in your query output
window, by dragging the divider down? (Between the record selectors at
left.)

 

[StopThisAdvertising]

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1075 users have come from the newsgroups requesting help
(e-mail address removed)

--

To the OP:
Adjusting the fontsize of your query might help you.

Also:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R

 

[Ron2005]

Rich,

Font size is one that can help some.

I have partially resolved this in some cases by having the column width
relatively small on the datasheet views, but added code so that if the
user double clicks on the field it opens a popup that displays the
whole field and allows them to edit it (as necessary or allowed for
that form).

 

[Guest]

Instead of looking at your data in a query, you might think about using a
form, which can put fields on different lines, thus allowing you to view all
the fields in a more compact way.

 

[John Vinson]

I'm looking for advice on how to handle queries that are too wide to fit on
your computer screen. I have too many fields, a couple of which are extremely
wide themselves. Unfortunately, I need to be able to see everything at
once...scrolling back and forth is not a logical option for my purposes.

Any suggestions would be great.

Basing a Form on the query is certainly one way to get more
flexibility in the display. You can have a continuous form with two or
three lines per record; you can "zoom" data in an individual textbox
(or even datasheet field if you wish) by setting focus to it and
typing Shift-F2.

John W. Vinson[MVP]