Vertical colum formatting for Insert

Hi
I'm using SQL management studio with the SQL set to SQL Server 2000.

When I set the format for an INSERT as follows:

	Code:
	INSERT ... ( ..., ... ) VALUES ( ..., ... )

I get the following format when I highlight the code and use CTl-F11:

	Code:
	INSERT INTO Activity ( ID, ShopID, CustID, Comments, MileageInterval, CouponTitle1 ) VALUES (1, 2, 3, 'duh', 4, 'sss' )

Why won't the VALUES part format vertically?

Rob

Have you modified wrong format style? Perhaps modified PL/SQL Style 1, but CTRL+F11 used T-SQL Default Style, or something like that?

I am using T-SQL predefined 1. As a test, I removed the vertical formatting from the INSERT section checked the results (It worked) and then restored it (It came back as vertical).

	Quote:
	It came back as vertical

I'm sorry, I didn't get it. Did you mean that it started working ok after the change?

The insert part came back to vertical. The values part stays horizontal.

	Code:
	INSERT INTO Activity ( ID, ShopID, CustID, Comments, MileageInterval, CouponTitle1 ) VALUES (1, 2, 3, 'duh', 4, 'sss' )

On the formatting style level set the "Text Length for in-line Brackets" option to 0. Hope this helps.

Thanks!