Autoformat query text to be readable?

[jacktripper]

I am taking over a database project from a previous developer who insisted on building massive, gigantic queries which are basically huge nested IIf statements. IFf within Iff within Iff. It makes it incredibly difficult to read and understand what is actually going on.

Is there any such tool that will autoformat the query so its indented and readable? Or easily converted into something that is more akin to an If/Else/ElseIf series of statements?

I haven't done a ton of access 2003 programming, so this kind of "ugly code" is a little frustrating to me.

Thanks in advance for any help.

 

[MazeWorX]

I use an access addin called MZ Tools it has a 'Smart indent' tool for code modules ... I havnt tried it but you might try to paste the code into a module and run the wizard? untested

just do an internet search for it.

hth


Remember amateurs built the ark - professionals built the Titanic

[flush]

 

[jacktripper]

I've done some searching, but haven't found anything like the tool I need yet. I will try this MZ thing and see.