Prev: Default font for forms in Access 2007
Next: Form Subform DLookup
From: John F on 7 Jun 2010 12:02
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?
From: Douglas J. Steele on 7 Jun 2010 13:05
"John F" <JohnF(a)discussions.microsoft.com> wrote in message
news:C27846C8-DB7E-42B7-BE67-E9FD96E09AC1(a)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!)



From: John W. Vinson on 7 Jun 2010 15:39
On Mon, 7 Jun 2010 09:02:53 -0700, John F <JohnF(a)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]
From: Peter Hibbs on 7 Jun 2010 16:30
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(a)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?
 | 
Pages: 1
Prev: Default font for forms in Access 2007
Next: Form Subform DLookup