Change the default format of the query design view

When I use the query design view, I have to increase the size of the table 
window (from which I'm selecting fields) sideways and vertically to see the 
field names more clearly and that also means moving the criteria grid further 
down the page to make room.  Is there a way to change the default table 
window size and default grid position so that I dont' have to do this every 
time?

Thanks,
Pat
0
Utf
7/24/2007 7:28:02 PM
access.queries 6343 articles. 1 followers. Follow

2 Replies
1642 Views

Similar Articles

[PageSpeed] 47

Pat

When you find it, let the newsgroup know!  You are (unfortunately) not the 
first person to wish there was a setting...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Pat" <Pat@discussions.microsoft.com> wrote in message 
news:FAD75995-69E5-452D-97F4-258FAC3EB33D@microsoft.com...
> When I use the query design view, I have to increase the size of the table
> window (from which I'm selecting fields) sideways and vertically to see 
> the
> field names more clearly and that also means moving the criteria grid 
> further
> down the page to make room.  Is there a way to change the default table
> window size and default grid position so that I dont' have to do this 
> every
> time?
>
> Thanks,
> Pat 


0
Jeff
7/24/2007 10:23:13 PM
Hi Pat

This is a really big frustration for me too!
I see that this was posted over 6 months ago.
Did you ever find a way to change this default view?

Regards,
Mark G

"Pat" wrote:

> When I use the query design view, I have to increase the size of the table 
> window (from which I'm selecting fields) sideways and vertically to see the 
> field names more clearly and that also means moving the criteria grid further 
> down the page to make room.  Is there a way to change the default table 
> window size and default grid position so that I dont' have to do this every 
> time?
> 
> Thanks,
> Pat
0
Utf
3/6/2008 4:05:05 PM
Reply:

Similar Artilces:

Mail format
If I attempt to send HTML mail, recipients outside our corporation receive the message in rich text format. Other doesn't have that problem. What settings should I check? ...

Formatting Text in a Forwarded Email Message
Odd problem in Outlook on one of our pc's. We are using Outlook 2002 SP3. When attempting to forward a message, I sometimes change a few of the words in the body of the message. I place the cursor within the word I wish to change. As soon as I type one letter, any letter, the letter shows up two font sizes bigger (from 12 to 14), and with a space on each side of the inserted letter. What seems to make this more puzzling is that when I attempt the same task on our other pc, everything functions as it should; no change in font size and no extra spaces. Any help in eli...

My format toolbar dissappeared and won't come back... Outlook 2003
I don't mean, grayed out. I mean not there. HTML, Rich text, doesn't matter. Any ideas? Is it turned off or actually deleted? Did you try resetting toolbars? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newslette...

Avery label format to landscape.
I would like to change the format for Avery label # 5164 from portrait to landscape but the option is grayed out. Create a text box that will fit, rotate it clockwise 90�, create your label, rotate it counterclockwise (or anti-clockwise) 90�. Ta dum -- JoAnn Paules MVP Microsoft [Publisher] "wpgmb" <wpgmb@discussions.microsoft.com> wrote in message news:14388E9C-EF0E-42FE-B54F-F1786D72851E@microsoft.com... >I would like to change the format for Avery label # 5164 from portrait to > landscape but the option is grayed out. ...

custom format
I need to custom format my Y axis the only on the top number of the scale to appear with the $ sign and the rest of the numbers #,###. Thanks You could use one of the axis label tricks that Jon Peltier explains here: http://www.peltiertech.com/Excel/Charts/ArbitraryAxis.html John Knoke wrote: > I need to custom format my Y axis the only on the top number of the scale to > appear with the $ sign and the rest of the numbers #,###. Thanks > > -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html A simpler solution is to change the ...

Change a text box to a combo box
Hi there I have created several forms in my database. I realized that I should have made them combo boxes instead of text boxes. Is there any easy way for me to change them into the format I need? Thank you in advance for your help. Right-click on the text box and select changeTo from the menu. -- Reggie "forest8" <forest8@discussions.microsoft.com> wrote in message news:FD867B89-38CC-4F20-A9AE-C177444DA9DA@microsoft.com...the > Hi there > > I have created several forms in my database. > > I realized that I should have made them combo ...

Book1
C:\Program Files\Microsoft Office\Office10\XLStart\Book1.xl -- mdalb ----------------------------------------------------------------------- mdalby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=705 View this thread: http://www.excelforum.com/showthread.php?threadid=26311 The template should be named Book.xlt, not Book1.xlt. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "mdalby" <mdalby.1d31an@excelforum-nospam.com> wrote in message news:mdalby.1d31an@excelforum-nospam.com... > >...

Can I make my Contacts Folder my Default
Does anyone know if I can make my contact folder the default folder rather than the Global Address List? On 3/8/2010 7:36 PM, Wendy wrote: > Does anyone know if I can make my contact folder the default folder rather > than the Global Address List? Sure. Ctrl-Shift-B (or just click the Address Book icon) Tools -> Options -- Leonid S. Knyshov Crashproof Solutions 510-282-1008 Twitter: @wiseleo http://crashproofsolutions.com Microsoft Small Business Specialist Please vote "helpful" if I helped you :) ...

Change Default View #2
Is it possible to determine a user's business unit and set the account entity default view depending on the business unit? I know it is not standard, I just am not sure if there is a way through javascript or the SDK to do it. Thanks You may be able to use a plug-in on the SavedQuery RetriveMultiple event. Here is an example to hide system views :- http://msdynamicscrm-e.blogspot.com/2008/02/hiding-view-in-crm-40-using-plug-in.html This is just a starting point to give you an example. You would have to check if the query being passed is to return the default view, and if so overr...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

File set up query.
Can i set up an excel file to open automatically on pc start up? The easiest is to use the Startup folder available in the Start Menu. To access it go to Start - Programs - Startup. You can delete or add tasks here according to your needs. They will start after Windows logon. When you start Excel, all the files that are located in the XLStart folder are automatically opened. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened. To specify an alternative startup folder, in Microsoft Excel 2002 or Microsof...

Can a user's Worlplace be defaulted to a standard one
Hi, Is it possible to set a standard Workplace that users will see based on either their role or team? We have a client who wants to set standard worplaces for respective teams/users. TIA Hi GP, Ian Watson had a good method-- "simply click on Workplace bar, then just above click on "personalize Workplace" then tick on or off what you need" This could also be done through changing the security role to allow certain privaleges. You cant change a system security role, you have to copy it and rename it. Settings | Security Roles | highlight the role you want to copy | ...

Wnat to change email address of Public Folder email address with Exchange 2003! Get error
The HTTP service used by Public Folder is not avialable, possible are that the Public stores are not mounted and the Information Store service i snot running. Id no: c1030af Exchange System Manager Used as part of SBS 2K3 Publick folders and information services are started and working properly! Questions? 1) How to fix Public stores are not mounted? How? 2) Fixed with Exchange SP1 "Walt Smith" <walts@yahoo.com> wrote in message news:z0Nqe.59554$887.53617@tornado.socal.rr.com... > The HTTP service used by Public Folder is not avialable, possible ...

Reconnecting after workstation hardware change.
I work in a medical centre running a single SBS 2003 server, and 7 workstations all running Win XP. I recently updated three of the workstations - built new boxes, cloned the drives from each, ran the Win XP repair option, and installed the new drivers. All seemed to be going well, until I placed the new workstations into the network. Though the login process seems to operate as previously the server based software is not functioning, and the network printer cannot be accessed. In addition I cannot see the network via Windows Explorer, but I can access the internet. When I put the old...

Changing paper feed trays
I am publishing a 4 page news letter and printing it off on a HP laserjet IIID with mail merge. Now my question is I would like to print the first page (front and back) from one tray which has colored paper and print the second page (front and back) from the bottom tray which has white paper. I know in word I can use letter head paper in on tray and print the first sheet with letter head and the rest with plane paper. can this be done with publisher. I am useing publisher 2000 Deluxe. A small child turns to Ed, and exclaims: "Look! Look! A post from Ben Davis <bfdavis@da...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

MS Query help!
I am in need of using excel and MS Query to intersect 2 tables, one in oracle and one in an excel spread sheet. I have come up with various work arounds, but none seem to be worth it unless I know that this is absolutely impossible in normal circumstances. how can I have 2 data sources for one join query in MS Query. best regards, Alexandre Brisebois ...

Default form in Public Calendar folder
I have a calendar in the public folders. Is there any way so that when the user clicks on the "New" button in Outlook that the default form that opens is a "Meeting Request" as opposed to an appointment? Thanks! Sylvia <sylvia@nospam.com> wrote: > I have a calendar in the public folders. Is there any way so that > when the user clicks on the "New" button in Outlook that the default > form that opens is a "Meeting Request" as opposed to an appointment? I don't think so, but you can certainly click the down-arrow next to the New ...

Changing Worksheets
Is anyone aware a keyboard shortcut that will allow you to 'move' from one worksheet to another within the wame workbook. I'm looking for something similar to the ALT+TAB used to to 'move' from a active window to a different window. Hi CTRL+PGUP CTRL+PGDOWN -- Regards Frank Kabel Frankfurt, Germany Adam Eichenberger wrote: > Is anyone aware a keyboard shortcut that will allow you > to 'move' from one worksheet to another within the wame > workbook. > > I'm looking for something similar to the ALT+TAB used to > to 'move' from a...

CRM not starting after Domain Controller change
Hi all, I added a new domain controller in my domain. This worked fine, no replication problem or any other problem. But since, CRM (which runs on another server) doesn't start. SQL is running on the CRM server. Each time I try to access CRM through IE, I get a generic error message and the following event is logged on CRM server (event id 2) : MSCRM Platform Error Report -------------------------------------------------------------------------------------------------------- Error: Défaillance irrémédiable Error Message: Défaillance irrémédiable Error ...

Paste options default
Is there a way to change the default paste method from HTML to unformatted text? I always use keyboard shortcuts if at all possible when working. I often copy data around and never like it to be preformatted, but Ctrl-V always ends up copying the format, when all I want is the data. Is there an option or registry key which would allow me to change the default accordingly? Thanks MKS -- View my blog: http://madkingsoup.blogspot.com Cheaper than "What's On TV", and it tells you want you want to watch: http://getdigiguide.com/?p=1&r=63387 Hi AFAIK you can't change t...

Changing view of a new mail message
If you are having problems with the view when composing new messages in Outlook and font is to large try this: Open new message, go to Tab that says format text, then on the menu on the top you will see a zoom button. Click on zoom button and decrease size of zoom. ...

How to preserve Rich Text Format on replies??
Our Exchange server is version 5.5 still. I want to set up the Exchange server such that if a domain user replies to a message that arrived in Rich Text format from another Outlook user on the Internet the reply shall also be in rich text. As it is now our users receive the message in rich text. Then they reply and edit the reply with rich text so they can color code certain parts of it. And they also copy the reply to a user in the same company, i.e. on the same Exchange server. But when the reply is sent out to the original sender he receives the message in plaintext, whereas the internal...

email address changing
We are experiencing a problem where users email address are changing by themselves. The users have an alias that we setup during user creation that is different from the username. Out of the blue they are having email addresses that show up that are their username@domain.com and it is set as the primary address. Any ideas? thanks The Recipient Policy is the obvious candidate. Take a look and post back to the list if that is not the source of the problem. Nue "Taylor" <user@home.com> wrote in message news:%23grbhzvFGHA.3100@tk2msftngp13.phx.gbl... > We are experien...

Formatting text
Is there a way to make sure all names in a column have the first letter upper case, and all other letters lower case? I believe you can in Access, but couldn't find the same option in Excel 2002. -- amab19 ------------------------------------------------------------------------ amab19's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29730 View this thread: http://www.excelforum.com/showthread.php?threadid=554419 =Proper(A1) Will turn first letter to a capital -- Saruman --------------------------------------------------------------------------- All Out...