# Disable Auto Format in Toad 12.7.1.11

**URL:** <https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 3, 2016, 12:17pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014 "2016-02-03T12:17:15Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ServiceAccount\_Toad](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@ServiceAccount\_Toad](https://forums.toadworld.com/u/ServiceAccount_Toad)\
**Post date:** [February 3, 2016, 12:17pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/1 "2016-02-03T12:17:15Z")

</div>

Hi,

I am not able to disable the auto formatting in Toad while discribing any object (F4) or while opening a object in Schema browser. Looks like there is option in other versions of TOAD. But looks like that option is modified or not in this version. Can you please help.

Thanks,

Selva

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 3, 2016, 12:20pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/2 "2016-02-03T12:20:58Z")

</div>

If you right-click somewhere in the package/procedure/function, near the bottom of the popup menu, you’ll find a menu item that says “Format code”. Uncheck it.

---

<div class="post-metadata">

**Author:** ![selvakumar.vpro](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@selvakumar.vpro](https://forums.toadworld.com/u/selvakumar.vpro)\
**Post date:** [February 23, 2016, 12:14pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/3 "2016-02-23T12:14:02Z")

</div>

Thanks a ton John, you Saved me. :-).

- I have done the steps you mentioned and now when I describe an object, toad doesn’t autoformat.

- Now when I drag and drop a sql file from project manager pane, its doing autoformat. I explored the options still I am not hitting the right setup. Please help.

Thanks,

Selva.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 23, 2016, 12:21pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/4 "2016-02-23T12:21:47Z")

</div>

Options -\> Editor -\> Open/Save -\> (RHS) -\> Format Files when opened.

Uncheck it.

---

<div class="post-metadata">

**Author:** ![selvakumar.vpro](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@selvakumar.vpro](https://forums.toadworld.com/u/selvakumar.vpro)\
**Post date:** [February 23, 2016, 1:24pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/5 "2016-02-23T13:24:15Z")

</div>

Thank you. it worked…

---

<div class="post-metadata">

**Author:** ![alanrosenthal](https://avatars.discourse-cdn.com/v4/letter/a/b77776/32.png) [@alanrosenthal](https://forums.toadworld.com/u/alanrosenthal)\
**Post date:** [September 11, 2017, 1:39pm UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/6 "2017-09-11T13:39:40Z")

</div>

I am able to disable the auto formatting for packages, procedures, and functions.

But it is still auto-formatting views when I open them from the schema navigator.

How can I turn auto-formatting of views (or of everthing) ?

Thanks

Alan

[arosenthal@transcendinsights.com](mailto:arosenthal@transcendinsights.com)

p.s. I love the formatting tool in toad. but not auto-formatting.

---

<div class="post-metadata">

**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\
**Post date:** [September 12, 2017, 4:42am UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/7 "2017-09-12T04:42:04Z")

</div>

Go into the SB LHS views tab -\> RHS Scripts tab and click the button to view script options. Uncheck “format” in the views tab.

---

<div class="post-metadata">

**Author:** ![alanrosenthal](https://avatars.discourse-cdn.com/v4/letter/a/b77776/32.png) [@alanrosenthal](https://forums.toadworld.com/u/alanrosenthal)\
**Post date:** [September 12, 2017, 9:10am UTC](https://forums.toadworld.com/t/disable-auto-format-in-toad-12-7-1-11/35014/8 "2017-09-12T09:10:21Z")

</div>

Thanks Brad. I actually had that box unchecked. But I tried checking it, clicking ok, going back in, unchecking it, and clicking ok again.

Now it seems to be working (ie. not auto formatting views)

thanks!
