Clever Geek Handbook

Funnel attribute fill size in Visio 2013?

Just a simple question from me, have been searched for hours but never found. I am doing a database design using the Crow Foot database notation in MS Visio 2013, Here is my design It looks like filling each attribute with their environment is too much. How can you reduce them? I can't find any tool to do this, tried increasing the font size, but the paddings seem to be bigger too.

Thanks before

+3


source to share


1 answer


The best decision

The best solution I have found is to edit the Crow foot stencil. This can be done using the following steps (all diagrams referencing the stencil must be closed):

  • In Windows Explorer navigate to the directory:
    % ProgramFiles% \ Microsoft Office \ Office15 \ Visio Content \ 1033 \
  • Right click and edit DBCROW_M.VSSX (for metric) or DBCROW_U.VSSX (for US). You might want to create a backup first.
  • In Visio, turn on developer mode if you haven't already. File-> Options-> Advanced, then under General, select Run in Developer Mode.
  • Right-click on the shape that you want to change, such as an attribute or primary key. Select edit master-> edit master shape.
  • The form will open. Right-click the shape and select Show Form Sheet.
    (If you don't have this option, Visio is not in developer mode.)
  • In Shape Transform-> Height change the height formula and enter.
    (See Formulas below.)
  • Close the form window and form. You will be prompted to update the form. Click Yes.
  • Save the stencil and close.

After completing these steps, the new stenciled objects will have a new height. You can also load an existing chart and change the shapes on it to a new shape.

Formulas

USA Original:
= GUARD (MAX (0.375 in, TEXTHEIGHT (TheText, TxtWidth), Sheet.6! TxtHeight))

New:
= GUARD (MAX (0.25 in, TEXTHEIGHT (TheText, TxtWidth) -0.125, Sheet.6! TxtHeight- 0.125)) '

Metric Original:
= GUARD (MAX (9 mm, TEXTHEIGHT (TheText, TxtWidth), Sheet.6! TxtHeight))
New:
= GUARD (MAX (6 mm, TEXTHEIGHT (TheText, TxtWidth) -3, Sheet.6! TxtHeight- 3))

As you can see in the US, I have reduced the height by 1/8 inch and metric by 3 mm. Feel free to adjust these dimensions as you see fit.



Alternative solution

Once I got Visio in developer mode, I was able to adjust the extra spacing around the attributes of the existing diagram without editing the stencil. Basically I did the same for the individual shapes.

  • Right-click Show Form Sheet.
  • Change the formula as above.

The problem is that it has to be done for every shape, which obviously takes a long time and it seemed like it came to life allowing me to save it.

Credit

I found this information on this post and Microsoft Documentation .

+5


source






More articles:


All Articles