Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Form_MultiColumn.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Form_MultiColumn.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Form_MultiColumn.mdb
    Posted: 09 Jul 2008 at 4:13am
    This sample db demonstrates multi-column layout in forms. This could be
convenient in situations where only a small number of fields are involved. Adoption
of multi-column layout (similar to across and then down layout in multi-column
reports), where records are arranged across the screen, can facilitate optimum
utilization of viewing area on continuous form or datasheet.

    Two alternative styles of multi-column display are covered (either style can be
selected via an option group):

    Style 1 - Complete transposition:
    1.1 - Field names appear at left, arranged in a vertical strip. Individual records
            appear across the screen as a series of vertical strips. For example, in a
            three column layout, there would be three data strips opposite the fieldname
            strip.
    1.2 - If it were a blank form to start with, only the first data strip would be
            available as a new record (adjacent to field name strip). As soon as data
            entry in this strip is initiated, a fresh data strip (as a new record) becomes
            available at the right of current strip.
    1.3 - When the last data strip at right is dirtied, a fresh strip of field names along
            with one blank data strip (representing new record) becomes available
             below the existing set of strips.

    Style 2 - Repetition of fields horizontally:
    2.1 - The set of columns representing a conventional record gets repeated
             across the screen. For example, if three fields F1, F2 and F3 are involved
            and three column layout is desired, the column headers will be like 
            F1 F2 F3  F1 F2 F3  F1 F2 F3
    2.2 - To start with, one horizontal strip spanning first set of fields will be available
            as new record. As soon as data entry in this strip is initiated, a fresh data
            strip (as a new record) becomes available at the right of current strip, under
            the next set of fields.
    2.3 - When the data strip under last set of field names is dirtied, a fresh blank
            data strip (representing new record) becomes available below the existing
            data strip under the first set of field names.

    For each style, both view are shown (continuous form as well as datasheet).
Toggling between the two views takes place on clicking the pertinent command
button. In datasheet view, there is certain wobble effect while conditional formatting
is updated. No such problem is experienced in continuous form view

    Data strip representing new record is highlighted in light blue. Blank cells (if any)
beyond this new data strip, are colored black, not available for use. Any attempt to
enter such forbidden strip deflects the focus back to new record strip.

    Deletion of records can be carried out by double clicking on the pertinent data
strip.

    Additional details are included in accompanying file Notes.txt

Download Access 2000: uploads/37/Form_MultiColumn.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.