Format of SQL Code

[Lou_Reed]

When I right click the title bar of the window and click SQL View I see the SQL code as follows:

SELECT Properties.[Property #], Properties.[Property Type], Properties.City, Properties.State, Properties.Bedrooms, Properties.Bathrooms, Properties.Condition, Properties.[Market Value]
FROM Properties
WHERE (((Properties.State)="VA")) OR (((Properties.State)="MD"));



Now I would rather see it like it is shown so often in the literature and examples. That is:

SELECT Properties.[Property #],
Properties.[Property Type],
Properties.City,
Properties.State,
Properties.Bedrooms,
Properties.Bathrooms,
Properties.Condition,
Properties.[Market Value]
FROM Properties1
WHERE (((Properties.State)="VA")) OR (((Properties.State)="MD"));



So is there a way to change the format to the latter type which I prefer.

Any help appreciated. Thanks in advance.




Respectfully,


Lou Reed

[orange]

Nothing native in Access.
You could write a function to do some reformatting.

You could use this to do some slight modification to layout. But it isn't part of Access.

It will convert this

SELECT Properties.[Property #], Properties.[Property Type], 
Properties.City, Properties.State, Properties.Bedrooms, 
Properties.Bathrooms, Properties.Condition, Properties.[Market Value]

FROM Properties

WHERE (((Properties.State)="VA")) OR (((Properties.State)="MD"));

to this

SELECT Properties.[Property #]
	,Properties.[Property Type]
	,Properties.City
	,Properties.STATE
	,Properties.Bedrooms
	,Properties.Bathrooms
	,Properties.Condition
	,Properties.[Market Value]
FROM Properties
WHERE (((Properties.STATE) = "VA"))
	OR (((Properties.STATE) = "MD"));

[Lou_Reed]

Thanks I will try it.

Respectfully,

Lou Reed