The standard layout for the datasheet view form is horizontal. Is there a way 
to display the datasheet view vertically with the field names going down the 
left side of the form and the data expanding to the right?

"John F" <JohnF@discussions.microsoft.com> wrote in message 
news:C27846C8-DB7E-42B7-BE67-E9FD96E09AC1@microsoft.com...
> The standard layout for the datasheet view form is horizontal. Is there a 
> way
> to display the datasheet view vertically with the field names going down 
> the
> left side of the form and the data expanding to the right?

No, there isn't.

-- 
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)
 

On Mon, 7 Jun 2010 09:02:53 -0700, John F <JohnF@discussions.microsoft.com>
wrote:

>The standard layout for the datasheet view form is horizontal. Is there a way 
>to display the datasheet view vertically with the field names going down the 
>left side of the form and the data expanding to the right?

Only with a third-party Grid control, or a very complex unbound form.
-- 

             John W. Vinson [MVP]

Not with the standard Access controls but you could use a Flex Grid
control to do this. Have a look at the Flex Grid Demo at :-

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4

for some examples. You will need to write some VBA code to do this
though.

HTH.

Peter Hibbs.

On Mon, 7 Jun 2010 09:02:53 -0700, John F
<JohnF@discussions.microsoft.com> wrote:

>The standard layout for the datasheet view form is horizontal. Is there a way 
>to display the datasheet view vertically with the field names going down the 
>left side of the form and the data expanding to the right?