database - Padding size of Crow's Foot Attribute in Visio 2013? -


just simple question me, have been searched hours didn't find any. i'm making database design using crow's foot database notation in ms visio 2013, here's design looks padding of each attributes surroundings big. how reduce them? can't find tool it, have tried increase font size paddings seems being bigger too.

thanks before

best solution

the best solution have found edit crow's foot stencil. can done using following steps (all diagrams referencing stencil must closed):

  1. in windows explorer navigate directory:
    %programfiles%\microsoft office\office15\visio content\1033\
  2. right click , edit dbcrow_m.vssx (for metric) or dbcrow_u.vssx (for us). might want them first.
  3. in visio turn on developer mode if haven't already. file->options->advanced under general select run in developer mode.
  4. right click on shape want change, example attribute or primary key attribute. select edit master->edit master shape.
  5. the shape open. right click on shape , select show shape sheet.
    (if don't have option visio not in developer mode.)
  6. under shape transform->height change height formula , enter.
    (see formulas below.)
  7. close shape sheet window , shape. prompted update shape. click yes.
  8. save stencil , close.

once these steps complete new objects created stencil have new height. can load existing diagram , change shapes on new shape.

the formulas

us 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 can see on reduced height 1/8 inch , on metric 3 mm. feel free adjust these sizes see fit.


alternative solution

once had visio in developer mode, able adjust spacing around attributes of existing diagram without editing stencil. did same thing individual shapes.

  1. right click select show shape sheet.
  2. edit formula above.

the problem has done each shape time consuming , seemed quirky letting me save it.

credit

i found information on this post , microsoft documentation.


Comments

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

c# - MSAA finds controls UI Automation doesn't -

wordpress - .htaccess: RewriteRule: bad flag delimiters -