"DWalker" <n***@none.com> wrote in message
news:O3xupgVlGHA.3732@TK2MSFTNGP05.phx.gbl...
>I had an earlier item about this in the newsfeed but I can't find it
> now.
>
> The Fonts and Colors dialog in SQL Server 2005 Management Studio is very
> confusing.
>
> When you use Management Studio to open a SQL database, and expand the
> list of views in that database, and right-click on one view and select
> the Modify item, you get a four-pane window that is divided into panes
> called:
>
> Diagram
> Criteria
> SQL
> Results
>
> (If you right-click in any pane you get a dialog box that lists Pane as
> a flyout, and it lists these panes, and you can turn any of these panes
> on or off.)
>
> I am having a helluva time figuring out how to change the fonts for the
> various panes.  I have managed to get all of the fonts changed to
> Verdana, but the SQL pane is using very small fonts.  I can't change
> this!
>
> It is a real disappointment that there's not a clearer and more obvious
> design.  I submit that this was poorly designed; if it was well-
> designed, then I would be able to figure it out -- because I'm a fairly
> smart guy.
>
> Here's a challenge:  Can ANYONE in the audience figure out how to change
> the font size in the SQL pane of the view designer, by looking in
> Tools/Options/Fonts and Colors?
>
> Sure, you can experiment, but if it was well-designed, you wouldn't HAVE
> to experiment.  I claim that if it takes experimentation to figure this
> out, then clearly, the design is flawed.
>
> However, the most-obvious choice in Fonts and Colors is "Table and
> Database Designers".
>
> But that choice gives me ONE font size to choose from, and it's clear to
> me that the font I see in the Criteria pane is much larger than the font
> in the SQL pane.
>
> Can anyone explain this rationally?  Are all 4 panes supposed to be
> covered by the one "Table and Database Designers" choice?  If so, why is
> the font smaller in the SQL pane than in the Criteria pane?
>
> And yes, I have closed and re-opened SQL Server Management Studio to get
> the changes to take effect.
>
> AAAaaaarrrgh.
>
> David Walker

"Gail Erickson [MS]" <ga***@online.microsoft.com> wrote in
news:#X38MVWlGHA.4080@TK2MSFTNGP03.phx.gbl:

>> Here's a challenge:  Can ANYONE in the audience figure out how to
>> change the font size in the SQL pane of the view designer, by looking
>> in Tools/Options/Fonts and Colors?
>
>   1.. On the Tools menu, click Options.
>   2.. Expand Environment, and then click Fonts and Colors.
>
>   3.. In the Show settings for list, select Data Viewer.
>
>   4.. Change the font  and size. Close SSMS and reopen to see the
>   change
>
> I agree that the choices in the Show settings for list are not
> intuitive, nor are they documented.  I'll file both a doc bug and a
> user interface design bug for these issues.
>
> Regards,
> Gail

"DWalker" <n***@none.com> wrote in message
news:OSAfLqXlGHA.1204@TK2MSFTNGP02.phx.gbl...
> "Gail Erickson [MS]" <ga***@online.microsoft.com> wrote in
> news:#X38MVWlGHA.4080@TK2MSFTNGP03.phx.gbl:
>
>>> Here's a challenge:  Can ANYONE in the audience figure out how to
>>> change the font size in the SQL pane of the view designer, by looking
>>> in Tools/Options/Fonts and Colors?
>>
>>   1.. On the Tools menu, click Options.
>>   2.. Expand Environment, and then click Fonts and Colors.
>>
>>   3.. In the Show settings for list, select Data Viewer.
>>
>>   4.. Change the font  and size. Close SSMS and reopen to see the
>>   change
>>
>> I agree that the choices in the Show settings for list are not
>> intuitive, nor are they documented.  I'll file both a doc bug and a
>> user interface design bug for these issues.
>>
>> Regards,
>> Gail
>
> None of the font choices seem to apply to the font that is used in the
> SQL pane, though.
>
> ALSO, changing Data Viewer doesn't change the size of the font in the
> Query window (the new window that you get after you click the New Query
> button).  That font is very small also.  although it seems to be the
> right family (verdana) that I picked for everything else.
>
> (Oh, how I hate Arial!  I can't read anything in Arial.  Verdana is a
> thousand times more readable.)
>
> Changing the settings for Data Viewer doesn't affect the size of the
> stuff that I type into the query window.
>
> Where do I change that?
>
> David Walker